Hi

I am new and have done a search but cannot find anything that exactly helps me.

I need to set up a spreadsheet that works out costs for re billing purposes. We get billed by our supplier and then we bill our customers at a higher rate.

I have the call duration in hh:mm:ss and I have the cost per minute.

Here are a couple of the rows from this month.

Destination Duration Cost p/m
Premium 00:04:52 £0.075
National 00:39:41 £0.010
Local 00:08:22 £0.010
02 Mobile 00:00:16 £0.075

What formula can I use to work out the costs? My mind has gone blank and everything I am trying doesn't work!

Any help will be muchly appreciated!