You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Junebug172 Author

Level 1

55 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

Top-ranking reply

Badunit

Level 7

27,982 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