Rounding time to the next minute

P

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
 
G

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
 
J

jeff

Hi,

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

with a zero.

works for me.
 
F

Frank Kabel

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