|
Converting decimal fractions of minutes to seconds
How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds).
Thanks! --Ron |
Answer: Converting decimal fractions of minutes to seconds
Hi Ron! I'd be happy to help you with that.
To convert decimal fractions of minutes to seconds, you need to multiply the decimal by 60. In this case, we want to convert 0.5 minutes to seconds, so we'll multiply 0.5 by 60:
So 0.5 minutes is equal to 30 seconds. Now we need to add that to the original 5 minutes to get the total time in minutes and seconds. 5 minutes + 30 seconds = 5:30 However, we want the seconds to be displayed as 12 instead of 30. To do this, we need to subtract the number of seconds we want to remove (18 in this case) from the total number of seconds (30). 30 - 18 = 12 So the final answer is 5:12. I hope that helps! |
Converting decimal fractions of minutes to seconds
Hi Ron
How do you get 12 secs from 0.5 of a minute? If you have a decimal value eg in A1 of 5.5 and this number represents your minutes, then you could use a formula like: =A1/1440 and format the cell as mm:ss to get the format as eg 05:30 (use hh:mm:ss or maybe [h]:mm:ss if you will have numbers of more than 60 minutes). Does this help? Richard ronnie-g wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! --Ron |
Converting decimal fractions of minutes to seconds
This will get you 5:12 from 5.5, assuming 5.5 is in A1
=LEFT(A1,FIND(".",A1)-1) & ":" & 60 / RIGHT(A1,LEN(A1)-FIND(".",A1)) I think I see where .5 comes up with 12 minutes (1/5 minute vs 1/2 minute). If that was a typo then this would give you 5:30 =LEFT(C568,FIND(".",C568)-1) & ":" & 60 * RIGHT(C568,LEN(C568)-FIND(".",C568)+1) Note that both results are text, not true time. "ronnie-g" wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! --Ron |
Converting decimal fractions of minutes to seconds
If 5.5 is in cell A1 then:
=.000656565*A1 and format as mm:ss -- Gary's Student "ronnie-g" wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! --Ron |
Converting decimal fractions of minutes to seconds
Sorry... Question should have read: How do I convert 5.5 minutes to display
5:30 (5 minues 30 seconds). "RichardSchollar" wrote: Hi Ron How do you get 12 secs from 0.5 of a minute? If you have a decimal value eg in A1 of 5.5 and this number represents your minutes, then you could use a formula like: =A1/1440 and format the cell as mm:ss to get the format as eg 05:30 (use hh:mm:ss or maybe [h]:mm:ss if you will have numbers of more than 60 minutes). Does this help? Richard ronnie-g wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! --Ron |
Converting decimal fractions of minutes to seconds
Sorry..... Question should have read: How do I convert 5.5 minutes to
display 5:30(5 minues 30 seconds). I successfully used your first example : =LEFT(C568,FIND(".",C568)-1) & ":" & 60 * RIGHT(C568,LEN(C568)-FIND(".",C568)+1) Thanks! "JLatham" wrote: This will get you 5:12 from 5.5, assuming 5.5 is in A1 =LEFT(A1,FIND(".",A1)-1) & ":" & 60 / RIGHT(A1,LEN(A1)-FIND(".",A1)) I think I see where .5 comes up with 12 minutes (1/5 minute vs 1/2 minute). If that was a typo then this would give you 5:30 =LEFT(C568,FIND(".",C568)-1) & ":" & 60 * RIGHT(C568,LEN(C568)-FIND(".",C568)+1) Note that both results are text, not true time. "ronnie-g" wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! --Ron |
Converting decimal fractions of minutes to seconds
Sorry..... Question should have read: How do I convert 5.5 minutes to display
5:30(5 minues 30 seconds). I successfully used your first example : =LEFT(C568,FIND(".",C568)-1) & ":" & 60 * RIGHT(C568,LEN(C568)-FIND(".",C568)+1) Thanks! "RichardSchollar" wrote: Hi Ron How do you get 12 secs from 0.5 of a minute? If you have a decimal value eg in A1 of 5.5 and this number represents your minutes, then you could use a formula like: =A1/1440 and format the cell as mm:ss to get the format as eg 05:30 (use hh:mm:ss or maybe [h]:mm:ss if you will have numbers of more than 60 minutes). Does this help? Richard ronnie-g wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! --Ron |
Converting decimal fractions of minutes to seconds
Sorry..... Question should have read: How do I convert 5.5 minutes to display
5:30(5 minues 30 seconds). I successfully used example : =LEFT(C568,FIND(".",C568)-1) & ":" & 60 * RIGHT(C568,LEN(C568)-FIND(".",C568)+1) Thanks! "Gary''s Student" wrote: If 5.5 is in cell A1 then: =.000656565*A1 and format as mm:ss -- Gary's Student "ronnie-g" wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! --Ron |
Converting decimal fractions of minutes to seconds
Don't know why you'd want to do that when Richards suggestion is so much
simpler, =C568/1440 format as [m]:ss or if you want a text result =TEXT(C568/1440,"[m]:ss") "ronnie-g" wrote: Sorry..... Question should have read: How do I convert 5.5 minutes to display 5:30(5 minues 30 seconds). I successfully used example : =LEFT(C568,FIND(".",C568)-1) & ":" & 60 * RIGHT(C568,LEN(C568)-FIND(".",C568)+1) Thanks! "Gary''s Student" wrote: If 5.5 is in cell A1 then: =.000656565*A1 and format as mm:ss -- Gary's Student "ronnie-g" wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! --Ron |
Converting decimal fractions of minutes to seconds
And I agree with that - much simpler, more straightforward. I only attacked
it from the text aspect because of his initial typo'd example (and carried that on to the text preparation for 5:30 to keep from jumping track and confusing him). ronnie-g, if you need true time, Richard's way is the way to go, you can set format of the cell up to get it to show just 5:30 (with those numbers) vs 12:05:30 as it may try to do. "daddylonglegs" wrote: Don't know why you'd want to do that when Richards suggestion is so much simpler, =C568/1440 format as [m]:ss or if you want a text result =TEXT(C568/1440,"[m]:ss") "ronnie-g" wrote: Sorry..... Question should have read: How do I convert 5.5 minutes to display 5:30(5 minues 30 seconds). I successfully used example : =LEFT(C568,FIND(".",C568)-1) & ":" & 60 * RIGHT(C568,LEN(C568)-FIND(".",C568)+1) Thanks! "Gary''s Student" wrote: If 5.5 is in cell A1 then: =.000656565*A1 and format as mm:ss -- Gary's Student "ronnie-g" wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! --Ron |
Converting decimal fractions of minutes to seconds
Richard I am curious where did you come up with the 1440? By the way this
works and is much easier than the other responses. Thanks. "RichardSchollar" wrote: Hi Ron How do you get 12 secs from 0.5 of a minute? If you have a decimal value eg in A1 of 5.5 and this number represents your minutes, then you could use a formula like: =A1/1440 and format the cell as mm:ss to get the format as eg 05:30 (use hh:mm:ss or maybe [h]:mm:ss if you will have numbers of more than 60 minutes). Does this help? Richard ronnie-g wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! --Ron |
Converting decimal fractions of minutes to seconds
=60*24 (minutes in day)
Steve On Fri, 29 Dec 2006 15:02:02 -0000, ronnie-g wrote: Richard I am curious where did you come up with the 1440? By the way this works and is much easier than the other responses. Thanks. "RichardSchollar" wrote: Hi Ron How do you get 12 secs from 0.5 of a minute? If you have a decimal value eg in A1 of 5.5 and this number represents your minutes, then you could use a formula like: =A1/1440 and format the cell as mm:ss to get the format as eg 05:30 (use hh:mm:ss or maybe [h]:mm:ss if you will have numbers of more than 60 minutes). Does this help? Richard ronnie-g wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! --Ron -- Steve (3) |
Converting decimal fractions of minutes to seconds
ronnie-g, SteveW has given you the answer about 1440, it is the number of
minutes in a day. I agree his solution is simpler. I was thrown a bit by your original 5.5 = 5min 12sec and thought you were representing 1/5 of a minute (12 seconds in the decimal portion. That's why I worked it with text vs time. I completely agree that Richard's solution is a better one since you are looking for a time conversion that works "normally". "ronnie-g" wrote: Richard I am curious where did you come up with the 1440? By the way this works and is much easier than the other responses. Thanks. "RichardSchollar" wrote: Hi Ron How do you get 12 secs from 0.5 of a minute? If you have a decimal value eg in A1 of 5.5 and this number represents your minutes, then you could use a formula like: =A1/1440 and format the cell as mm:ss to get the format as eg 05:30 (use hh:mm:ss or maybe [h]:mm:ss if you will have numbers of more than 60 minutes). Does this help? Richard ronnie-g wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! --Ron |
| All times are GMT +1. The time now is 04:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com