Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Add times, convert to number not time of day?
Okay, this should be pretty simple.
17:24:00 + 00:24:00 = 7 5:00 PM + 9:30 PM = 4.5 That's what i'm trying to achieve. A start time, a finish time, and the time it took between them. Not a clock time of 5pm + 9pm = 2am How can this be done? thanks, Benjamin |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Add times, convert to number not time of day?
i forgot, i might want to add this in.
I did this: a1 - 9:30 a2 - 10:00 a3 = a2-a1 the result is .02 ??? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Add times, convert to number not time of day?
=MOD(B1-A1,1)
format as hh:mm or [h]:mm -- Regards, Peo Sjoblom "spezticle" wrote in message ... Okay, this should be pretty simple. 17:24:00 + 00:24:00 = 7 5:00 PM + 9:30 PM = 4.5 That's what i'm trying to achieve. A start time, a finish time, and the time it took between them. Not a clock time of 5pm + 9pm = 2am How can this be done? thanks, Benjamin |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Add times, convert to number not time of day?
Oops! Make that
=MOD(B1-A1,1)*24 format as general or number -- Regards, Peo Sjoblom "spezticle" wrote in message ... Okay, this should be pretty simple. 17:24:00 + 00:24:00 = 7 5:00 PM + 9:30 PM = 4.5 That's what i'm trying to achieve. A start time, a finish time, and the time it took between them. Not a clock time of 5pm + 9pm = 2am How can this be done? thanks, Benjamin |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Add times, convert to number not time of day?
thank you very much :-D
just what I needed! "Peo Sjoblom" wrote: Oops! Make that =MOD(B1-A1,1)*24 format as general or number -- Regards, Peo Sjoblom "spezticle" wrote in message ... Okay, this should be pretty simple. 17:24:00 + 00:24:00 = 7 5:00 PM + 9:30 PM = 4.5 That's what i'm trying to achieve. A start time, a finish time, and the time it took between them. Not a clock time of 5pm + 9pm = 2am How can this be done? thanks, Benjamin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Number to Time | Excel Discussion (Misc queries) | |||
Convert time stored as decimalised number to time format | New Users to Excel | |||
Convert number to time | Excel Discussion (Misc queries) | |||
convert number to time | Excel Worksheet Functions | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) |