Cliff said:
Need to convert Minutes:Seconds format to minutes with seconds
converted to a decimal
That depends on (a) how you entered the data, and (b) what you mean by
"converted to a decimal". As always, specific examples will help us help
you.
For example, suppose you have 12:34.
First, what result do you want: 12.34, about 12.57 (exactly 12 + 34/60), or
something else (what?)?
Second, how did enter 12:34: simply as 12:34; as 0:12:34; or text of the
form 12:34? What is the format of the cell?
Format the cell as Number with 6 decimal places or more. Is the value about
0.523611 or 0.008727?
At issue is: you might have thought you entered min:sec, but it was
actually interpreted as hr:min.
If you entered 0:min:sec and the cell is formatted as mm:ss, and if the cell
displays about 0.008727 when you format it as Number as 6 dp, and if you
12:34 to be converted to about 12.57, you can convert as follows:
=A1*1440
which you can format as Number with 2 decimal places, if that's what you
want.
