View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default hours are less than eight hours

Set your workbook to 1904 calendar if you need to dieplay negative time.
Tools Options menu.

HTH. Best wishes Harald

"negative hours carried forward" <negative hours carried
skrev i melding
...
I know that the hours are less than eight hours and it needs to show as
negative however it works fine if you work more than eight hours but less
than 8 it shows as ######. Does anyone else know how to do this?