convert seconds to minutes

[ahphan]

Hi
I am in need of a formula for converting seconds to minutes as in the
following

0:12:15 (seconds <30) should be converted to 0:12:30 and
0:12:42 (seconds >30) should be converted to 0:13:00

Please help me

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.Rounding.html#time

 

[JE McGimpsey]

One way:

Since XL stores times as fractional days, you can get integer minutes
(that you can then round) by multiplying by 24*60 (=1440):

=ROUND(A1*1440,0)/1440

 

[Ron Rosenfeld]

Hi
I am in need of a formula for converting seconds to minutes as in the
following

0:12:15 (seconds <30) should be converted to 0:12:30 and
0:12:42 (seconds >30) should be converted to 0:13:00

Please help me

See if this works for you (with your time in A1)

=CEILING(A1,TIME(0,0,30))


--ron

 

[JE McGimpsey]

Oops, I read your title, and didn't notice your example conflicted.

To do what your example shows:

=CEILING(A1,1/2880)