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.
Great, thanks! However I'm really afraid of side effects, this is the kind of legacy option which is never tested...
A pity Microsoft does not fix the original issue, the format with brackets [h]:mm:ss;-[h]:mm:ss is supposed to work but this is bugged since forever. 😞
A pity Microsoft does not fix the original issue, the format with brackets [h]:mm:ss;-[h]:mm:ss is supposed to work but this is bugged since forever. 😞
If you don't use the 1904 date system, Excel cannot display negative times. Changing this would probably break other stuff, so it is very unlikely to happen.