RoundUp a time value

Hi guys,

I already took a look into other topics, but could not find anything that’s relatable with my situation.

Here is an example of what I want to accomplish:

I have the time value 0 hours 1 minute and 15 seconds (00:01:15).
I want the value to be always rounded up to the next minute value, in that example 0 hours 2 minutes 0 seconds (00:02:00).

Can anybody be so nice and help me to figure this out?


hi @Jannis ,

below my contribution, I am sure there are shorter solutions, others will point that out when they see mine :wink:

It is a tricky one, Cheers, Christiaan

1 Like

Or this one:


Thank you guys!



This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.