1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

minutes and seconds in excel

Discussion in 'Business Applications' started by helpmepleaseguys, Nov 22, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. helpmepleaseguys

    helpmepleaseguys Thread Starter

    Joined:
    Nov 22, 2011
    Messages:
    3
    I have a stumper here guys. i imported a call detail showing call times not time of day but length in calls. i'm trying to determine my phone usage since i am trying to switch to a business plan with lightpath. now i have optimum business and i have unlimited calls. lightpath you have set usage ex 10,000 minutes. i have generated a report for 30 days worth of calls but i can't add all 6000 some od calls myself so i was wondering if anyone could help. ive try to format and sum up the cells. i will attach the spreadsheet.
     
  2. helpmepleaseguys

    helpmepleaseguys Thread Starter

    Joined:
    Nov 22, 2011
    Messages:
    3
    see attachment please help thanks in advance
     

    Attached Files:

  3. edhicks

    edhicks

    Joined:
    Jun 30, 2008
    Messages:
    248
    see attached worksheet
     
  4. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    The example you provided contains 10061 minutes.

    Rollin
     
  5. edhicks

    edhicks

    Joined:
    Jun 30, 2008
    Messages:
    248
    see attached

    I can' seem to make the attachment

    my attachment is too large

    Rollin
    please double check your answer
    Does excell treat the text 4:30 as 4 hours and 30 minutes??? like your answer
    and does the submitted file mean 4 mim 30 sec
    I think your answer is 60 times actual answer presuming 4 min 30 sec is correct
    I will condense my attachment and try to get to show up

    Rollin is correct I lost the days in my total
     
  6. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    I am treating the values in the workbook as minutes:seconds and I'm fairly certain that my calculations are correct. An easy way to check is to use the "Text to Columns" option to split each cell using the colon character as the delimiter. This will result each cell being split into 2 columns (minutes and seconds) The sum of the first column will give you the total number of minutes. The sum of the second column will give you the total number of seconds which can then be divided by 60 and added to the first number for the total number of minutes.


    Rollin
     
  7. edhicks

    edhicks

    Joined:
    Jun 30, 2008
    Messages:
    248
    see post 5

    I goofed
    edhicks
     
  8. helpmepleaseguys

    helpmepleaseguys Thread Starter

    Joined:
    Nov 22, 2011
    Messages:
    3
    Yes these are all minutes and seconds. So you are saying its 60,000 minites?
     
  9. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    As I previously stated there are 10061 minutes

    Rollin
     
  10. edhicks

    edhicks

    Joined:
    Jun 30, 2008
    Messages:
    248
    No, Rollin is correct 10,061 minutes is total.
     
  11. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1028048

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice