Cost per min formula

[mr_m_cox]

Hi All,
I have a call costs spreadsheet that shows me call cost and call duration. How can I work out the cost per min of that call?

I have duration in column G and cost in Column H

Duration shown as xx:xx:xx
Cost shown as £xx.xx

Thanks all.

 

[Roderick_E]

divide by 60? We need to know the actual format of the Duration. Is it HH:MM:SS hour, minute, second and how is that cell formatted? General? Text? Time? Thanks

 

[mr_m_cox]

Hi,
The duration is formatted as "Custom" with a type of hh:mm:ss

 

[AlanY]

so, that will be p/min

=H1*100/(G1*24*60) or

£/min

=H1/(G1*24*60)

 

[mr_m_cox]

Hi,

Thanks for the help.
Using the £/min formula against a duration of 00:53:31 and cost of 94.19 its returning 18:14:25 in the formula cell? Wrong formatting?
Thanks.

 

[AlanY]

your formula cell is formatted as date/time, change it to number format should work

Excel 2013/2016
	G	H	I
1	00:53:31	94.19	1.76
Sheet1

Cell Formulas
Range	Formula
I1	=H1/(G1*24*60)

 

[mr_m_cox]

your formula cell is formatted as date/time, change it to number format should work

Excel 2013/2016

	G	H	I
1	00:53:31	94.19	1.76

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula I1 =H1/(G1*24*60) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Your a star, thanks @AlanY

 

[AlanY]

You’re welcome