I need a quicker formula

[wmustudent99]

Situation:

I currently have a number in mm:ss format (A1). I need to multipl
this number by a cents per minute number. I need to conver the mm:s
number into a format that will be able to calculate the total cost.

This is the formula I currently have and I believe there is a muc
faster one out there.

Example:

A1 = 32.25 (mm:ss)

My Formula =((MOD(A1,1))/0.6)+(INT(A1))

Results are 32.42. I can now calculate this number to find out tota
cost.

Any help would be great. Thank

 

[David McRitchie]

multiply by 24 hrs x 60 minutes because
time is a fraction of a day. If you want to show the
minutes in a cell format as a number with decimal places.

More information on Date and Time
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/datetime.htm

 

[Don Guillett]

try
=e1*24

 

[Stephen Bye]

=DOLLARDE(A1,60)
will convert 32.25 (32 minutes and 25 seconds) to 32.42 (32 point 42
minutes)