Negative Time Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a timesheet which calculates flexi - but I can's get it to show
negative time eg:

flexi = totalhoursworked - 36(standardhours) + overtimecarriedover.

In a situation where this should be negative the result goes round the 24
hour clock again - so I'm getting 22:00 rather than -02:00 - any ideas?
 
Switch to the 1904 date system

Tools>Options>calculation and check the 1904 date system box.



--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top