Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculatnig total time in excel
I want to keep track of an employees earned hours, but the calculation will
also need to keep track of negative hours i.e. 5:12 on monday and -2:12 on Tuesday giving an end calculation of 3:00 any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculatnig total time in excel
Change the workbook to the 1904 date system via Tools Options
Calculation and check the 1904 date system. Be warned that all existing dates will change by 1,461 days. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Training Guy" wrote in message ... I want to keep track of an employees earned hours, but the calculation will also need to keep track of negative hours i.e. 5:12 on monday and -2:12 on Tuesday giving an end calculation of 3:00 any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
calculate total service time in excel | Excel Discussion (Misc queries) | |||
Grand total time between two total cells | Excel Discussion (Misc queries) | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) |