+ Reply to Thread
Results 1 to 3 of 3

Calculating total from number of minutes and cost p/m

  1. #1
    Registered User
    Join Date
    08-06-2009
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    2

    Calculating total from number of minutes and cost p/m

    I need to calculate the total cost of outbound calls based on the total duration of outbound calls multiplied by cost per minute.

    For example, in a given month, the total duration of outbound calls is 261:16:34 being 216 hours, 16 minutes and 34 seconds. I have this figure in cell A1 with the format [h]:mm:ss.

    I then convert this to minutes in cell B1 by saying B1=A1, but having the format [m], which gives me 15676.

    In cell C1, I have the cost per minte value of £0.026. But when I apply the formula D1=B1*C1, I get £0.283, when 15676*£0.026 should in fact be £407.58.

    Any ideas?
    Last edited by Macey141; 08-06-2009 at 05:46 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Calculating total from number of minutes and cost p/m

    No need for B1 as I see it

    D1: =INT(A1*1440)*C1

  3. #3
    Registered User
    Join Date
    08-06-2009
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Calculating total from number of minutes and cost p/m

    Excellent, thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1