View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MarcusLesser MarcusLesser is offline
external usenet poster
 
Posts: 1
Default 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?