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

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]00:53:31[/TD]
[TD="align: right"]94.19[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"]1.76[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I1[/TH]
[TD="align: left"]=H1/(G1*24*60)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Your a star, thanks @AlanY

 

[AlanY]

You’re welcome