Rounding time to the next minute

[Paul D]

Rounding time to the next minute
I have a time 00:02:12 I need to have as a numberic value
and rounded up to the netx minute, I need to get a value
of 3

 

[Frank Kabel]

Hi
try
=ROUNDUP(A1*24*60,0)/(24*60)
and format the resulting cell as time

 

[Guest]

I tried

=ROUNDUP(G2*24*60,1) / (24*60),

The Value of G2 is 0:02:11 and I get a value of 0:02:12, I
need to get a numberic value of 3.

Under the same breath I also need to track hours in
minutes... Any ideas

Framk - you are great, I have been trying to accomplish
many things for quite a while, and you have always lead me
down the right path... THANK YOU

 

[jeff]

Hi,

Change
=ROUNDUP(G2*24*60,1) / (24*60)
to
=ROUNDUP(G2*24*60,0) / (24*60)

with a zero.

works for me.

 

[Frank Kabel]

Hi
as i posted use
=ROUNDUP(G2*24*60,0) / (24*60)
so change the ,1 to ,0 in the ROUNDUP function

 

[JE McGimpsey]

One way:

=CEILING(A1,"0:01")