| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Linear Mode
