Hi All,

I am having to workout my companies telephone bill to make sure the
carrier isn't charging more than what we agreed, I have done a few
calls manually but with 20,000 calls im not doing them all.

What I have is:-
The duration
The cost per minute
The connection charge

This is one example using easy numbers:-
Duration 1 minute received as 00:01:00
Cost Per Min received as 0.12p twelve pence per min
Connection Charge as 0.02p two pence

But here's my problem if I do =(00:01:00*0.12)+0.02 it doesn't work,
if i do it using cell referances I get the result of 0.020083333

So to get round this I put the time in as a calculation =((mm*60)+ss)/
60 but I have to do this for each call. is there a easier way?

Cheers
Mark :o)