Home |
Search |
Today's Posts |
#1
|
|||
|
|||
format a timesheet it adds the hrs but need a negative for flex
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 |
#2
|
|||
|
|||
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? juls kartinyeri wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
protecting format | Excel Discussion (Misc queries) |