minutes and seconds in excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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.
 
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
 
Joined
Sep 4, 2003
Messages
4,916
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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top