Home 
Search 
Today's Posts 
#1




Converting decimal fractions of minutes to seconds
How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds).
Thanks! Ron 
#2




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 ronnieg wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! Ron 
#3




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. "ronnieg" wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! Ron 
#4




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 "ronnieg" wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! Ron 
#5




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 ronnieg wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! Ron 
#6




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. "ronnieg" wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! Ron 
#7




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 ronnieg wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! Ron 
#8




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 "ronnieg" wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! Ron 
#9




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") "ronnieg" 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 "ronnieg" wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! Ron 
#10




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). ronnieg, 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") "ronnieg" 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 "ronnieg" wrote: How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds). Thanks! Ron 
Reply 

Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Converting minutes to seconds  Excel Worksheet Functions  
Converting a decimal time into hours and minutes  Excel Worksheet Functions  
converting seconds into minutes  Excel Worksheet Functions  
converting a decimal number to hours and seconds  Excel Worksheet Functions  
converting from digital degrees to degrees minutes seconds  Excel Worksheet Functions 