Trying to round UP to minute

[Paul D]

I have a Time field 0:01:08, I need to round up to the
next minute, I need a result of the interger 2

How do I structure a formula

 

[Peo Sjoblom]

One way

=CEILING(A1,1/1440)*1440

format as general where A1 holds the time

 

[Harald Staff]

Hi

1 is a day, which makes 0:01 very small (1/(24*60)). If you need an integer
minute then first multiply by 1440 and then round up:

=CEILING(A1*1440,1)

HTH. Best wishes Harald