Forum Discussion
Birgir_F
Oct 31, 2021Copper Contributor
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...
Juliano-Petrukio
Oct 31, 2021Bronze Contributor
- click File tab, and select Options from the menu list. And the Excel Options dialog will open.
- click Advanced from the left pane, and check Use 1904 data system under When calculating this workbook section. Click Ok button
Another option is to make-up it by using TEXT() and MAX() and MIN() formulas if you want it time formatted (HH:MM)
=TEXT((MAX(Q35:Q36)-(MIN(Q35:Q36)+K37)),CHOOSE(N(Q36<Q35)+1,"-[H]::MM","[H]::MM"))
Find attachment