I need a quicker formula

  • Thread starter Thread starter wmustudent99
  • Start date Start date
W

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
 
=DOLLARDE(A1,60)
will convert 32.25 (32 minutes and 25 seconds) to 32.42 (32 point 42
minutes)
 
Back
Top