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 |
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) |