Assistance with Microsoft Excel

[pulling wire]

I would like to know how to formulate cost per minute calculations. I know that 00:45:00 will cost me R75 if the hourly rate is R100, what I dont know is how to calculate this in excel.

 

[memakda]

Hmmm
Cost per min = hourly rate / 60
total cost = number of mins * cost per min

 

[SirFooK'nG]

Hmmm
Cost per min = hourly rate / 60
total cost = number of mins * cost per min

yip...

if A = Rate/Hour
and
B = Time (in minutes)

Cost=((A/60)*B)

You may also want to change the hour to a number i.e 45min = .75 of an hour * 100
your format for the time would be custom hh:mm
and the format for the calcultated decimal time would be number with 2 decimals (00:45*24)
Then multiply your (rate) by the decimal
eg

Cost=(time*24)*rate

 

[pulling wire]

I have a phone call costing R9.86 and its duration is 5:04 How would I work out cost per minute, is there a formula or do I manually have to process
R9.86 / (5X60+4) = 9.86/304 = 0.032X60 = R1.92 per minute

 

[SirFooK'nG]

I have a phone call costing R9.86 and its duration is 5:04 How would I work out cost per minute, is there a formula or do I manually have to process
R9.86 / (5X60+4) = 9.86/304 = 0.032X60 = R1.92 per minute

A=Cost of Call
B=Duration of Call (format hh:mm:ss)

Cost/Minute=(A/(minute(B)*60+second(B))*60

=R1.95p/min

 

[pulling wire]

You are the man! thanks IRG.