If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need to convert Minutes:Seconds format to minutes with seconds con
Need to convert Minutes:Seconds format to minutes with seconds converted to a
decimal |
#2
|
|||
|
|||
Need to convert Minutes:Seconds format to minutes with seconds con
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Need to convert Minutes:Seconds format to minutes with seconds con
=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 |
Thread Tools | |
Display Modes | |
|
|