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


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?