convert 28:55 (mm:sec) to 28.92 (mm.mm)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've looked at the other posts and the formulas I've tried don't work ....

Need formula and format to convert mm:sec to mm.mm (minutes and hundreths of
minutes).

Any help appreciated!

Mike
 
A1 = 28:55 (formatted as mm:ss)

=A1*1440 (formatted as GENERAL or NUMBER)

Biff
 
Let's say your A1 =0:28:55

B1 =ROUND(A1*24*60,2)
format cell as general
 
You must log in or register to reply here.

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

convert length of time to minutes from hundreths 2
16.36 convert to 16:36 (min:sec) 5
Converting Seconds to Hours, Minutes, Seconds 3
Access Convert a decimal time to hours and minutes 2
Convert minutes into hours 3
Converting time to decimal format 17
Round hh:mm:ss to whole hh:mm 3
Which is the best MBOX Converter Tool different formats conversion? 4

Back
Top