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

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

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

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

=A1*1440 (formatted as GENERAL or NUMBER)

Biff

"Sailonmike" wrote in message
...
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

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

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

This works too. Thanks!

"Biff" wrote:

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

=A1*1440 (formatted as GENERAL or NUMBER)

Biff

"Sailonmike" wrote in message
...
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

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

This works! Thanks

"Teethless mama" wrote:

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

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

You're welcome!

Biff

"Sailonmike" wrote in message
...
This works too. Thanks!

"Biff" wrote:

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

=A1*1440 (formatted as GENERAL or NUMBER)

Biff

"Sailonmike" wrote in message
...
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