Times are rounding up
How do I remove seconds from a time calculation? The PM add should be 10:30 for a GTTL of 31:31.
Question marked as
Top-ranking reply
I don't think any of the rounding functions work on durations so it has to be converted to a decimal number of minutes, turned into an integer, then converted back.
=DURATION(,,,INT(DUR2MINUTES(IF(C2="PM",E2*1.5,E2))))