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.
How do I remove seconds from a time calculation? The PM add should be 10:30 for a GTTL of 31:31.
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))))
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))))
Thanks so much!!!! That did the trick.
HNY.
Times are rounding up