Excel Excel Time calculation

[flower5555]

Total call time 00:29:05 total cost of calls 0.4985
What sum do I put in excel to get the cost of call per min??

 

[Sifou]

Hey Flower5555,

If you'll always have the time in the hh:mm:ss format, the following should help you:

If A2 Cell contains 00:29:05 and B2 contains the total cost, the below formula should give you the answer:

=(B2/SUM(HOUR(A2)*60*60,MINUTE(A2)*60,SECOND((A2))))*60

a break down:

= (Total Cost of Call/(number of hours in seconds + number of minutes in seconds + number of seconds)) * 60 to reconvert the whole to minutes

I hope this helps.

Sifou

 

[flower5555]

I can't thank you enough for that, you have cut my work load down to less than a quarter. I still dont understand how it works but it does and thats good enough for me. Thank you

 

[flower5555]

While I have your brains, how would I go from cost per minute x by time to get the total cost.

0.08 cost per min x 00:29:05 = Total cost?

 

[Sifou]

Hi Flower5555,

Not a problem at all, I need to give back a bit to the communities where i find answers to my own technical problems;

For the total price based on the price per minute and time spent on the call: same principle, however if the below formula gives you a result on the 00:00:00 form instead of a decimal price, change cell (or cell range) formatting to number:

=(SUM(HOUR(A2)*60*60,MINUTE(A2)*60,SECOND((A2))) / 60) * C2 (Assuming C2 is where you hold your unit price (Price per minute)

Cheers,
Sifou

 

[flower5555]

Thank you, you been really helpful )

 

[Kevin@Radstock]

Hi

For your first question, can you not use.
=(B2/A2)/1440

And the following for the second part, assuming C2 contains 0.08.
=A2*1440*C2