Quick help with excel formula

Ok, i need a forumla.

this is what I want, i have two columns like this

Time Start: .............
Time Finish: ............

I fill out these two columns like this

Time Start: ...17:42...
Time Finish: ...18:25..

Now i have another Column that says

Training Length: ........

I want this to work out the time between 17:42 and 18:25

Any one help pleas

--
Message posted from http://www.ExcelForum.com

0
8/9/2004 2:28:04 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
972 Views

Similar Articles

[PageSpeed] 55

Hi
simply
=A2-A1
and format as time

If your training time can span midnight use the formula
=A2-A1+(A2<A1)

>-----Original Message-----
>Ok, i need a forumla.
>
>this is what I want, i have two columns like this
>
>Time Start: .............
>Time Finish: ............
>
>I fill out these two columns like this
>
>Time Start: ...17:42...
>Time Finish: ...18:25..
>
>Now i have another Column that says
>
>Training Length: ........
>
>I want this to work out the time between 17:42 and 18:25
>
>Any one help please
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>
0
frank.kabel (11126)
8/9/2004 2:38:50 PM
Have you tried subtracting one from the other?

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"ABC_BOXER >" <<ABC_BOXER.1aq6kq@excelforum-nospam.com> wrote in message
news:ABC_BOXER.1aq6kq@excelforum-nospam.com...
> Ok, i need a forumla.
>
> this is what I want, i have two columns like this
>
> Time Start: .............
> Time Finish: ............
>
> I fill out these two columns like this
>
> Time Start: ...17:42...
> Time Finish: ...18:25..
>
> Now i have another Column that says
>
> Training Length: ........
>
> I want this to work out the time between 17:42 and 18:25
>
> Any one help please
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>


0
Don
8/9/2004 2:39:28 PM
Don't forget to put hh between [] otherwise it will not count more than 24
hours

Rex


"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:2b5601c47e1e$962c2290$a501280a@phx.gbl...
> Hi
> simply
> =A2-A1
> and format as time
>
> If your training time can span midnight use the formula
> =A2-A1+(A2<A1)
>
> >-----Original Message-----
> >Ok, i need a forumla.
> >
> >this is what I want, i have two columns like this
> >
> >Time Start: .............
> >Time Finish: ............
> >
> >I fill out these two columns like this
> >
> >Time Start: ...17:42...
> >Time Finish: ...18:25..
> >
> >Now i have another Column that says
> >
> >Training Length: ........
> >
> >I want this to work out the time between 17:42 and 18:25
> >
> >Any one help please
> >
> >
> >---
> >Message posted from http://www.ExcelForum.com/
> >
> >.
> >


0
8/9/2004 2:51:04 PM
Reply:

Similar Artilces:

need help
Humaneyes from Israel really sucks! ...

need excel to repeat oddly :)
starting with number 7334 7334 7334 7335 7335 7335 7335 7335 7335 7335 7335 7335 7335 7335 7335 7335 7335 7335 7335 7335 7336- 8 times 7337- 7 times 7338- 6 times 7339- 7 times 7340- 8 times 7341- 7 times 7342- 4 times 7343- 8 times 7344- 6 times 7345- 4 times 7346- 6 times then I need it to repeat from the top, but the next number would be i sequence...7347 I need this to go to 761 -- gotzoo ----------------------------------------------------------------------- gotzoom's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3065 View this thread: http://www.excelfo...

Help with Columns
Hi Everybody: I have this excel spreadsheet from a co-worker and the problem that i'm having is that the columns only go to AK and I want to to go to beyond that. My question is: is there a way to get it to show all the columns like when you start a new speadsheet? joe They might be hidden or restricted by a scroll area macro. Why don't you ask the co-worker??? -- Don Guillett SalesAid Software Granite Shoals, TX donaldb@281.com "joe" <ranchan02@hotmail.com> wrote in message news:013b01c34ae5$d68432a0$a101280a@phx.gbl... > Hi Everybody: > > I have th...

default appointment times problems
When i re-open outlook and go to the calender, all the appointments times have changed to 1am on the start day - 1am on the day after it waqs meant to finish. So a 12 day appointment is now shown as over 2 days. How do you change the default appointment time settings so an appointment which is just typed into the day is from 9am - 5pm for example and will stay as a 1 day event when opening and closing outlook? All day events are 12 -12, not 9-5. If you want it 9-5, you need to make it for 9-5. All day appointment change to 1 -1 if you change the time zone or DST settings aft...

Emailing Worksheet from Excel
Hi all, I am trying to email a worksheet from excel 2003. I am following th directions, but it always attaches the entire workbook and not just th open worksheet. When troubleshooting, i notice I do not have the email icon on m toolbar, and help says this is because I do not have outlook on m computer. I do have Outlook 2003... is there a way I can associat these so I can send my worksheet? Many thanks in advance -- Message posted from http://www.ExcelForum.com Hi see: http://www.rondebruin.nl/sendmail.htm -- Regards Frank Kabel Frankfurt, Germany > Hi all, > > I am tryi...

Copying certain column information quickly
As you know in Excel you could quickly copy the information you needed with a drag of the mouse. Because I need information copied repeatedly and easily for my access unfirmiliar co workers. Example JOB CUSTOMER QUOTE # A B1 110701 A(copied) A2 110701 (copied) A(copied) C4 110701 (copied) How do I do this quickly and efficiently for the computer challenged. Sorry, Access is a database, not a spreadsheet, and can't be used like one. You can write some code to select the rows that you want to ...

Windows Keys: Help Request
I have a problem with an Excel program that the members of our golf club use to enter golf scores. The program runs full screen and users cannot exit or use other programs without a password. The problem is some of the brighter young members are using the Windows keys to access the rest of the computer. Is there a way to disable these keys? And to disable the cool switch (alt/tab). Hi you should probably ask this question in a Windows newsgroup as this is not an Excel issue :-) -- Regards Frank Kabel Frankfurt, Germany Monte Comeau wrote: > I have a problem with an Excel program ...

Quick help with excel formula
Ok, i need a forumla. this is what I want, i have two columns like this Time Start: ............. Time Finish: ............ I fill out these two columns like this Time Start: ...17:42... Time Finish: ...18:25.. Now i have another Column that says Training Length: ........ I want this to work out the time between 17:42 and 18:25 Any one help pleas -- Message posted from http://www.ExcelForum.com Hi simply =A2-A1 and format as time If your training time can span midnight use the formula =A2-A1+(A2<A1) >-----Original Message----- >Ok, i need a forumla. > >this is what ...

Quick Question
I have been using Office 2007 and OneNote for some time now and have recently set up the 2010 Beta on a second system. In the 2007 version there was a way to repair office if things went flaqky. How do I do that in Office 2010? Michael On Tue, 8 Dec 2009 23:59:26 +0000 (UTC), Rev. Michael L. Burns <sdbpastor@charter.bet> wrote: > >I have been using Office 2007 and OneNote for some time now and have recently >set up the 2010 Beta on a second system. In the 2007 version there was a >way to repair office if things went flaqky. How do I do that in Office 2...

Help! How can I upload data and display it in Excel on client
side. Also, how can I open a book with several sheets on client side? (It is a web application). Thanks. ...

h:mm:ss formula
How would you calculate the total times if your times were entered as: Example Column C:C will have 5 for 5 minutes, .30 for 30 seconds, 15 for 15 minutes. And so on... I can't seem to figure out how to tell excel that a decimal number is seconds and a whole number is minutes. Up to 59 minutes, then my sum total time would be h:mm:ss. Thanks so much for your help!!! On Sun, 10 Apr 2011 18:27:59 -0700 (PDT), Dick <bobdelrn@yahoo.com> wrote: >How would you calculate the total times if your times were entered as: >Example >Column C:C will have 5 for 5 minutes, .30 for 30 seco...

duplicate transactions-HELP!
If anyone knows how to fix this, I would appreciate your help! I am using Money 2003 Deluxe, downloading directly from my bank (not from MSN site). When I pay my bills online, the bill will show in the register using the 'estimated' date it is removed from the account (I need the 'actual due date' to show here to avoid confusion). Better yet, when it is downloaded from the bank and I accept the matched transaction, it is logged in again on a different date (date cleared) leaving a duplicate transaction. I didn't catch this until recently and it has really messed u...

Help with sql which counts records
Could someone help me to extend this sql to include: 1. a count of txtsole where the field is a YES/NO field and I want a count of where the answer is YES 2. a count of txtmulti where the field is a YES/NO field and I want a count of where the answer is YES 3. a count of txtsole where the field is a YES/NO field and I want a count of where the answer is YES 4. a count of txtnbrparts where the field is a number field and I want a count of where the answer greater than 1 I think I need to extend the WHERE statement? SELECT tblhvdealspt1.txtablhybrid, Count(*) AS totals, tblhvdealspt...

Need help with MS Money Plus
I know that MS Money is no longer being supported, but, until my system actually spits the app off the hard drive, I'll continue to use it. When I heard earlier this year that Money was discontinued, I purchased the last version of Money Plus. I am now attempting to archive 2 years' worth of data. I've created the earlier year archive, but, when I opened my primary Money file, all the earlier transactions were still there. All the other versions of Money removed the transactions from the primary file. What is going on and how do I get Money to remove those transactions? Also, ...

Need formula to add increments of 0.16 seconds to time
Need assistance in development of a formula to add increments of 0.16 seconds to time formated as 00:00:00.00 (hh:mm:ss.00). Tim, =A2 + TIMEVALUE("0:0:0.16") -- Earl Kiosterud www.smokeylake.com "Tim Ashcom" <Tim Ashcom@discussions.microsoft.com> wrote in message news:D6D45229-0751-4106-A907-90DEBD806F1D@microsoft.com... > Need assistance in development of a formula to add increments of 0.16 > seconds > to time formated as 00:00:00.00 (hh:mm:ss.00). Hi, Say the date/time is in A1, use: = A1 + 16 * (1/24/60/60/100) ie: one day is 1 for excel...

Excel Chart Problem!!! (Bug I think)
This is a multi-part message in MIME format. ------=_NextPart_000_00B9_01C93A2D.3C166610 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Try the folloing. 1. Open Excel. 2. Paste the following data A B C D E F=20 2008 10 20 30 40 0 10=20 3. Menu Insert/Pie (select the first Pie type) 4. Right Click one of the top of any part of the circle/Format Data = Series 5. Click Shadow and move any of the slides on the right.=20 See what happend on the chart. The problem is that the ZERO generates a full circle and you can drag = and ...

Help with Outlook 2003
I have way too many emails in OUTLOOK--about 9,000 or so and now cannot delete, nor download, and am basically dead in the water--any advise? Tool box repair kit was no help--Thanks for any reccomendations, K Kathy <anonymous@discussions.microsoft.com> wrote: > I have way too many emails in OUTLOOK--about 9,000 or so > and now cannot delete, nor download, and am basically > dead in the water--any advise? Tool box repair kit was > no help--Thanks for any reccomendations, The number of messages you have has no bearing on the problem at all. Why not post the exact text ...

Budget Help
I have transaction information from January 2002 up to the present. I want to do a budget, however, everytime I try to create a budget there is no data from my transactions. It is like the autobudget function does not work at all. Any suggestions as to what I am doing wrong? ...

excel macro mail send
Hello, I'm using this vb macro code for sending mail. --------------------------------------------------------------- Sub mailto_Selection() Dim Email As String, Subj As String, cell As Range Dim response As Variant Dim msg As String, url As String Email = "" 'create list below Subj = "Family Newsletter" msg = "Here needs to be named range from excel(some text)" '-- Create the URL For Each cell In Selection Email = Email & cell.Text & "; " Next cell url = "mailto:" &...

Excel 2007 question
I recently upgraded to excel 2007. Whenever I open one of my spreadsheets I get a warning bar that says Security warning automatic update of links has been disabled. However I do not see links any where. How I can quickly locate them. Thanks ...

How can I change the cursor color in Excel?
How can I change the cursor color in Excel? Normally when you stand on any cell, the selected cell shows a black border with a dot in the right bottom. When you have a sheet with different border styles, it is difficult to see which cell is selected. How can I change that cell-selection-border color? I think you problem was answered elsewhere; however, you can look at: http://cpearson.com/excel/RowLiner.htm cmckeever "Pierre" <Pierre@discussions.microsoft.com> wrote in message news:74C4ACC6-27E7-4122-9FB9-697C1361F598@microsoft.com... > How can I change the...

Help on Macro
I have searched far and wide for this! Please help. I use Word 2003 (Professional) in an on-line program. If I'm away from the program for more than 5-10 minutes, the program shuts down. I need a macro that will make my screen appear as if I'm using Word when I'm not, so that the program does not shut down. Something simple like arrowup, arrowdown, arrowup, arrowdown, or whatever. Just so it doesn't mess up the part of the report I've typed. I think it's called a looping macro. I need it to continue on until I'm back at the screen and ready to type and...

In Publisher my photo cuts in half and prints double, help!
I can enter photos on my flyer created in Publisher and then when I go to enter my personal photo it takes the photo when printing and cuts it in half and doubles it in the photo box. When I preview it before I print it, it looks just fine and it only does it for the one photo and it is always the agent's photo. We are in real estate. I would be happy to fax anyone a sample so you can see exactly what I am talking about so that you could help me! I have Microsoft Office 2003 Professional. Pictures print multiple times in a Publisher 2003 publication http://support.microsoft.com/def...

Is there a quick way to...
highlighting only the odd or even numbered rows? Thanks. Something like this should do: Sub banding() ActiveSheet.Range("A65536").Select Selection.End(xlUp).Select lastrow = ActiveCell.Row Range("A6:AK" & lastrow).Select Selection.Interior.ColorIndex = xlNone 'Change rownum to the the first row number where data occurs rownum = 6 For i = 1 To (lastrow - rownum) Step 2 Range("B" & rownum + i & ":AK" & rownum + i).Select With Selection.Interior .ColorIndex = 15 .Pattern = xlSolid End With ...

A tough problem with rotas. I need Help.
Hi, This is really bugging me. i have a weekly roster of 35 staff members in the following format ................A.....................B...................C.................D ....................E 1............<<merged cells - Heading>>................................................. 2....................................11th.............12th...............13t h..............14th.........'text entries to show date 3...........Name...............Friday............Saturday.......Sunday...... .....Monday....'text entries of the day 4...........Staff 1............10:30 - 5:0...