Negative Time Format
 

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?

Negative Time Format
 

Switch to the 1904 date system

ToolsOptionscalculation 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)

"MarcusLesser" wrote in message
...
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?