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...
Excel cannot handle negative times (except by changing a setting, but that would mess up all dates in your workbook). A workaround is to display the total times as decimal hours instead of as time. See the attached version.