Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting time to number, i.e. 2:32 to 2.32
I'm figuring song royalties based on the length of the song. My songs are
listed in minutes/seconds, such as 2:32. In order to calculate the royalty, I need the time converted to a number. Multiplying by 24 does not work. I simply need a song length like 2:32 converted to 2.32. Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting time to number, i.e. 2:32 to 2.32
You could convert it into decimal minutes like this:
=A1*24*60 which will show as 2.53333 etc. If you really want it in the form you show, you could do this: =MINUTE(A1)+SECOND(A1)/100 but you should not really do any arithmetic directly on that. Hope this helps. Pete On Apr 22, 4:34*pm, Kokomojo wrote: I'm figuring song royalties based on the length of the song. *My songs are listed in minutes/seconds, such as 2:32. *In order to calculate the royalty, I need the time converted to a number. *Multiplying by 24 does not work.. *I simply need a song length like 2:32 converted to 2.32. *Thank you! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting time to number, i.e. 2:32 to 2.32
Why do you want 2:32 converting to 2.32? Perhaps you've forgotten that
there are 60 seconds in a minute? 2 minutes and 32 seconds is 2.5333333 minutes. If you have 0:2:32 and multiply by 24*60, you'll get 2.5333333 If you have 2:32:0 (i.e. 2 hours and 32 minutes) and multiply by 24 you'll get 2.5333333 What number did you get when you multiplied by 24? What do you mean by "does not work"? -- David Biddulph "Kokomojo" wrote in message ... I'm figuring song royalties based on the length of the song. My songs are listed in minutes/seconds, such as 2:32. In order to calculate the royalty, I need the time converted to a number. Multiplying by 24 does not work. I simply need a song length like 2:32 converted to 2.32. Thank you! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting time to number, i.e. 2:32 to 2.32
You are right on all counts. Thanks.
"David Biddulph" wrote: Why do you want 2:32 converting to 2.32? Perhaps you've forgotten that there are 60 seconds in a minute? 2 minutes and 32 seconds is 2.5333333 minutes. If you have 0:2:32 and multiply by 24*60, you'll get 2.5333333 If you have 2:32:0 (i.e. 2 hours and 32 minutes) and multiply by 24 you'll get 2.5333333 What number did you get when you multiplied by 24? What do you mean by "does not work"? -- David Biddulph "Kokomojo" wrote in message ... I'm figuring song royalties based on the length of the song. My songs are listed in minutes/seconds, such as 2:32. In order to calculate the royalty, I need the time converted to a number. Multiplying by 24 does not work. I simply need a song length like 2:32 converted to 2.32. Thank you! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting time to number, i.e. 2:32 to 2.32
This was VERY helpful, and you are right, I want it to convert to 2.5333.
Thanks! "Pete_UK" wrote: You could convert it into decimal minutes like this: =A1*24*60 which will show as 2.53333 etc. If you really want it in the form you show, you could do this: =MINUTE(A1)+SECOND(A1)/100 but you should not really do any arithmetic directly on that. Hope this helps. Pete On Apr 22, 4:34 pm, Kokomojo wrote: I'm figuring song royalties based on the length of the song. My songs are listed in minutes/seconds, such as 2:32. In order to calculate the royalty, I need the time converted to a number. Multiplying by 24 does not work.. I simply need a song length like 2:32 converted to 2.32. Thank you! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting time to number, i.e. 2:32 to 2.32
You are right on all counts. Thank you!
"Glenn" wrote: Kokomojo wrote: I'm figuring song royalties based on the length of the song. My songs are listed in minutes/seconds, such as 2:32. In order to calculate the royalty, I need the time converted to a number. Multiplying by 24 does not work. I simply need a song length like 2:32 converted to 2.32. Thank you! Are you sure you don't want 2:32 converted to 2.5333? =MINUTE(A1)+SECOND(A1)/60 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting time to number, i.e. 2:32 to 2.32
Kokomojo wrote:
I'm figuring song royalties based on the length of the song. My songs are listed in minutes/seconds, such as 2:32. In order to calculate the royalty, I need the time converted to a number. Multiplying by 24 does not work. I simply need a song length like 2:32 converted to 2.32. Thank you! Are you sure you don't want 2:32 converted to 2.5333? =MINUTE(A1)+SECOND(A1)/60 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting time to number, i.e. 2:32 to 2.32
You're welcome - thanks for feeding back.
Pete On Apr 22, 5:23*pm, Kokomojo wrote: This was VERY helpful, and you are right, I want it to convert to 2.5333. * Thanks! "Pete_UK" wrote: You could convert it into decimal minutes like this: =A1*24*60 which will show as 2.53333 etc. If you really want it in the form you show, you could do this: =MINUTE(A1)+SECOND(A1)/100 but you should not really do any arithmetic directly on that. Hope this helps. Pete On Apr 22, 4:34 pm, Kokomojo wrote: I'm figuring song royalties based on the length of the song. *My songs are listed in minutes/seconds, such as 2:32. *In order to calculate the royalty, I need the time converted to a number. *Multiplying by 24 does not work.. *I simply need a song length like 2:32 converted to 2.32. *Thank you!- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Time to a Number | Excel Discussion (Misc queries) | |||
converting number to time | Excel Discussion (Misc queries) | |||
Converting a decimal number into time | Excel Discussion (Misc queries) | |||
converting a number to time | Excel Worksheet Functions | |||
Converting whole number to TIME | Excel Discussion (Misc queries) |