Forum Discussion
Excel - how to show a negative time calculation
I am creating a time sheet that calculates the time used against a starting amount of hours purchased for consulting. I have used the "time" calculation to delete the time used. I have now got to whe...
In the desktop version of Excel for Windows:
Select File > Options.
Select Advanced in the navigation pane on the left.
Scroll down to the section 'When calculating this workbook'.
In Excel for Mac, the 1904 date system is the default setting.
I have been working on a spreadsheet, not huge...but when I changed to the 1904 system, it increased all my dates by 4 years....but now does show negative values in my time difference column
Yes, dates will change if you switch from the 1900 date system to the 1904 date system.
If you want to correct existing dates:
- Enter the number 1462 in an empty cell.
- Copy this cell.
- Select a range with dates that are 4 years off.
- Right-click in the selection.
- Select Paste Special... from the context menu.
- Select Subtract.
- Click OK.