Negative Time Format

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

 

[Bob Phillips]

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)