time questions (roundup & convert hh to mm

G

Guest

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.
 
B

Biff

Hi!

1.

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

2.

Custom format as [mm]:ss

01:01:05 = 61:05

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting MM-DD HH:MM out of Julian date 4
Macro in Excel 2
MROUND time 2
sum time in hh:mm:ss format 1
Calculating time differences across two (or more) dates 1
Excel Convert Datetime Stamp to HH and MM Worked 7
Converting dd:hh:mm to [h]:mm not working. 3
Change date format from US to English (Australian) 3

Top