format a timesheet it adds the hrs but need a negative for flex

  • Thread starter juls kartinyeri
  • Start date
J

juls kartinyeri

I have been working on a timesheet for work I've got the format to add the
hrs for the day and the total for the week but when the overtime adds on to
the flex it want give me a negative it just comes up with ######## can you
please help thanks
 
D

Dave Peterson

One way to show negative dates/times in excel is to use the 1904 date system.

Tools|Options|Calculation tab

Be aware that any dates in your worksheet will change by 4 years and a day.

But if you're adding hours, how do you get a negative value?
 
Top