RoundUp a time value

[Jannis]

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?

Sincerely
Jannis

[Christiaan_Huizer]

hi @Jannis ,

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

It is a tricky one, Cheers, Christiaan

[joost_mineur]

Or this one:

[Jannis]

Thank you guys!

@Christiaan_Huizer
@joost_mineur

Sincerely
Jannis