Excel Billing Formula

  Leepaci 15:18 10 Sep 2009
Locked

I receive an excel spreadsheet every month which details mobile bills including the minutes and pence per minute for each call.

I need to enter a formula which will total the cost of each call but the call duration is in the format hh:mm:ss and the cost is in 0.00. How can I create a formula to multiply the call duration by the cost per minute column and get the answer in a currency format?

ANy help would be greatly appreciated on this one.

  VoG II 15:18 10 Sep 2009

With a duration in A1, p/minute in B1 then in C1

=A1*1440*B1

Format C1 as Number (or Currency).

  VoG II 15:19 10 Sep 2009

Or to get the cost in £

=A1*1440*B1/100

  Leepaci 16:02 10 Sep 2009

Thank you very much VoG!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Converse draws on iconic heritage for a fresh brand identity

Mac power user tips and hidden tricks

Comment lancer Windows 10 en mode sans échec ?