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...
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.