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!