software

hi, 2 questions please...
1st. i have durations in column A in hh:mm:ss format. How do I round them up
to the next minute (ex. 01:01:05 should be 01:02:00)

2nd how do I convert hh to mm in the above example (ex 01:01:05 should
apear as 61:05 (where 61 are mm and 05 ss)

Thank you,

S.

Hi!

1.

=CEILING(A1,1/1440)
=CEILING(A1,TIME(0,1,0))

2.

Custom format as [mm]:ss

01:01:05 = 61:05

Biff

quot;stevenquot; gt; wrote in message
...
gt; hi, 2 questions please...
gt; 1st. i have durations in column A in hh:mm:ss format. How do I round them
gt; up
gt; to the next minute (ex. 01:01:05 should be 01:02:00)
gt;
gt; 2nd how do I convert hh to mm in the above example (ex 01:01:05 should
gt; apear as 61:05 (where 61 are mm and 05 ss)
gt;
gt; Thank you,
gt;
gt; S.