PendleBusinessSolutions
asked on
How to calculating cost per Minute in Excel 2007
I'm trying to sum all the different tariffs on a phone bill to Calculate the cost per minute in excel, so I can do a cost comparison with other providers...
E.g.
Local Calls: 21 hours, 15 minutes, 30 seconds (21:15:30) I have been charged £22.04
National Calls: 26 hours, 26 minutes, 42 seconds (26:26:42) I have been charged £26.33
I would then like total these to get an average cost per minute across Local and Nation Calls.
I have made some progress, in that 21 hours if charged £22.04 comes out at 1.7pence per minute,
But when it goes over 24 hours it goes haywire...
Cheers Guy's.
Chris
E.g.
Local Calls: 21 hours, 15 minutes, 30 seconds (21:15:30) I have been charged £22.04
National Calls: 26 hours, 26 minutes, 42 seconds (26:26:42) I have been charged £26.33
I would then like total these to get an average cost per minute across Local and Nation Calls.
I have made some progress, in that 21 hours if charged £22.04 comes out at 1.7pence per minute,
But when it goes over 24 hours it goes haywire...
Cheers Guy's.
Chris
Brad Sims
Unless I'm mistaken, you'll need to multiply the number of hours * 60 to get the number of minutes and divide by the total.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Barry, your the man... many thanks, it works great...
I've just saved a client over 40% on their Landline calls and 30% on Mobiles...
Regards,
Chris.
I've just saved a client over 40% on their Landline calls and 30% on Mobiles...
Regards,
Chris.
Glad to hear that Chris - is the cheque in the post?!