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
|