Oct 31 2021 09:23 AM
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 for displaying negative results?
Oct 31 2021 09:45 AM - edited Oct 31 2021 10:24 AM
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
Oct 31 2021 09:46 AM
Oct 31 2021 09:51 AM
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.
Oct 31 2021 08:37 PM