Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to I subtract two dates & times to obtain a time
Hi folks, I have hopefully what will be a quick and easy question.
I have two colums (A & B) that hold two date and time values, a start and complete time. Jul 19 2009 08:30 Jul 19 2009 12:54 I want to be able to find out the actual time difference, for example above would show 4:24 hours. In some cases the start and complete dates could be a day or 2 apart, therefore I would want the output to be displayed in hour format, for example: Jul 17 2009 08:30 Jul 19 2009 12:54 Column C should be 52:24 hours. Is there a way to do this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Total Time With Dates/Times That Overlaps | Excel Discussion (Misc queries) | |||
How do I find elapsed time between 2 dates and times? | Excel Worksheet Functions | |||
calculate elapsed time between dates and times | Excel Worksheet Functions | |||
HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
Subtract time and dates with restrictions | Excel Worksheet Functions |