View Single Post
  #3  
Old June 18th, 2009, 05:10 AM posted to microsoft.public.excel.worksheet.functions
joeu2004
external usenet poster
 
Posts: 1,748
Default Need to convert Minutes:Seconds format to minutes with seconds con

"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.