Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=A2-A1
where A2 is end time and A1 is start time, then format result custom as [hh]:mm -- Regards, Peo Sjoblom "Alistair" wrote in message ... I am using Excel 2003. I have a date and time, each in its own column. I also have another date and time, each in its own column. I need to find the exact elapsed time between the two date/time sets, and most of the time, the elapsed time is over 24 hours. How do I write the formula to give me the exact elapsed time? Thank you for any help you can give. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL 2003 Dates & elapsed time | Excel Discussion (Misc queries) | |||
calculate elapsed time between dates and times | Excel Worksheet Functions | |||
Ref: Formula to calculate elapsed time between certain dates and t | Excel Discussion (Misc queries) | |||
how do i find # hrs & mins. between 2 different dates and times | Excel Worksheet Functions | |||
Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) |