Thread: Converting time to number, i.e. 2:32 to 2.32
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kokomojo Kokomojo is offline
external usenet poster
  
Posts: 18
Default 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

Reply With QuoteReply With Quote