Thread: convert 28:55 (mm:sec) to 28.92 (mm.mm)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default convert 28:55 (mm:sec) to 28.92 (mm.mm)
Let's say your A1 =0:28:55

B1 =ROUND(A1*24*60,2)
format cell as general


"Sailonmike" wrote:

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
Reply With QuoteReply With Quote