Need to convert Minutes:Seconds format to minutes with seconds converted to a
decimal

One way with minutes seconds entry in A1.

=(TEXT(A1,"[s]")+0)/60

If this post helps click Yes
---------------
Jacob Skaria


"Cliff" wrote:

Need to convert Minutes:Seconds format to minutes with seconds converted to a
decimal

"Cliff" wrote:
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.

=A1*1440 and format as number or general.
--
David Biddulph

Cliff wrote:
Need to convert Minutes:Seconds format to minutes with seconds
converted to a decimal