| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Length of time from date/time custom format
I am working with a database that uses one of the custom date/time formats,
specifically m/d/yyyy h:mm. I want to calculate the time difference between two cells in this format; however, when I do a simple subtraction (for example =A1-B1) the result is displayed again as a date and time. What I want is to be able to determine the difference in time between the two values (for example, the difference between 1/2/2000 13:00 and 1/1/2000 12:00 would be 1 day, 1 hour (or 25 hours, or 1500 minutes). I appreciate any advice! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting time (hr:min) from date/time format | Excel Discussion (Misc queries) | |||
| Custom time format help | Excel Discussion (Misc queries) | |||
| Custom Date & Time format | Excel Worksheet Functions | |||
| Convert date to length of time in months from set date | Excel Worksheet Functions | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Threaded Mode
