convert seconds to minutes

  • Thread starter Thread starter ahphan
  • Start date Start date
A

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
 
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
 
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
Click to expand...

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

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


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

To do what your example shows:

=CEILING(A1,1/2880)
 
Back
Top