Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Calculation
What formula do I need to calculate elapsed time?
e.g. I need to calculate time from start to finish of a job and total elapsed time for a weekly time sheet. I want to enter start time and stop time for various activities and be able to subtotal and total time spent for driving and time spent on various jobs. I need to calculate total in both rows and columns. Thanks for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Calculation
To calculate elapsed time, just subtract the two cells, as in:
=a2-a1 Format the result as time. When you total the result, if you might want to use [hh]:mm as the format which will display times greater than 24 hours. -- Regards, Fred "Mike G" wrote in message ... What formula do I need to calculate elapsed time? e.g. I need to calculate time from start to finish of a job and total elapsed time for a weekly time sheet. I want to enter start time and stop time for various activities and be able to subtotal and total time spent for driving and time spent on various jobs. I need to calculate total in both rows and columns. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Calculation | Excel Worksheet Functions | |||
Time Calculation Formula! | Excel Discussion (Misc queries) | |||
perform calculation only if current time is after 10 am | Excel Worksheet Functions | |||
"Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
time calculation excel | Excel Worksheet Functions |