Forum Discussion
Format cell for displaying negative result when summing time format
Version: Microsoft® Excel® for Microsoft 365 MSO (Version 2109 Build 16.0.14430.20292) 64-bit Summing / subtracting time format "[tt]: mm;@" does not display negative results, how shall it be...
Hi,
there is only one way to work with negative times in Excel, which is to turn on the "Use 1904 date system" in the Excel options, advanced section. But this is something, I would not recommend (all dates are shifted by 4 years!)
Instead I propose to convert the times into decimal numbers by multiplying the time value with 24.
Kind regards,
Martin
there is only one way to work with negative times in Excel, which is to turn on the "Use 1904 date system" in the Excel options, advanced section. But this is something, I would not recommend (all dates are shifted by 4 years!)
Instead I propose to convert the times into decimal numbers by multiplying the time value with 24.
Kind regards,
Martin