Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Calculating Time Elapsed in Excel
Hi Everyone,
How can I calculate the time elapsed between two given times? For example if I input initial time and date as 20:00 on 03 Jan 06 and final time and date as 05:00 on 05 Jan 06, I want to calculate the number of hours elapsed. Moreover I am interested in whole numbers i.e. 8 hours and 31 minutes should round to 9 hours and 8 hours and 29 minutes should round to 8 hours. I need to multiply this time elapsed with another constant quantity? Any help would be appreciated. regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Elapsed Time | Excel Worksheet Functions | |||
Calculating elapsed time | Excel Discussion (Misc queries) | |||
Calculating Time elapsed | Excel Worksheet Functions | |||
Calculating elapsed time | Excel Worksheet Functions | |||
Calculating a rate for elapsed time? | Excel Discussion (Misc queries) |