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

[Sailonmike]

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

 

[Biff]

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

=A1*1440 (formatted as GENERAL or NUMBER)

Biff

 

[Teethless mama]

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

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

 

[Sailonmike]

This works too. Thanks!

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

=A1*1440 (formatted as GENERAL or NUMBER)

Biff

 

[Sailonmike]

This works! Thanks

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

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

 

[Biff]

You're welcome!

Biff

This works too. Thanks!