| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I calculate total time (24hr) with timesheets?
Creating a rota for 60 staff. I have start times e.g. 17.30 and a finish time
of 00.45. How do I calculate the total hours worked. if I just use 5 & 12.45 then a negative number appears. Please Help!! Jon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro / function text time to 24hr excel time passed midnight fortotaling hr's | Excel Worksheet Functions | |||
| calculate from time started and finished to get total time used | Excel Worksheet Functions | |||
| NEED A FORMULA TO CALCULATE DIFFERENCE BETWEEN TWO TIMES IN 24HR . | New Users to Excel | |||
| how to calculate overtime automatically on Excel timesheets | Excel Worksheet Functions | |||
| i need to calculate the total time from a start time to and end t. | Excel Discussion (Misc queries) | |||
Threaded Mode
