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 -