Converting time to number, i.e. 2:32 to 2.32

K

Kokomojo

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!
 
P

Pete_UK

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
 
D

David Biddulph

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"?
 
K

Kokomojo

You are right on all counts. Thanks.

David Biddulph said:
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"?
Click to expand...
 
G

Glenn

Kokomojo said:
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!
Click to expand...


Are you sure you don't want 2:32 converted to 2.5333?

=MINUTE(A1)+SECOND(A1)/60
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using time data copied and pasted into excel from external source 4
getting excel to recognise copied data as mm:ss not hh:mm 2
2 Formulas needed!!! :) 13
Conditional Time Calculation 10
Calculate the number of hours in a date/time cell 1
How to convert minutes to seconds 5
Have a list if descriptions to go in a list of cells 2
How to create a link from paragraph heading to an alphabetical ind 1

Top