calculatnig total time in excel

  • Thread starter Thread starter Training Guy
  • Start date Start date
T

Training Guy

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?
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top