Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Junebug172 Author

Level 1

49 points

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.

Posted on Dec 31, 2021 10:05 AM

Best reply

Badunit

Level 7

26,188 points

Posted on Dec 31, 2021 12:24 PM

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))))

View in context

Times are rounding up

Similar questions