Welcome to Comcast Help & Support Forums
Find solutions, share knowledge, and get answers from customers and experts

New to the Community? Start here.

5,787,835

members

68

online now

1,938,138

discussions

Top

Downloading History of Dialed/Received/Missed calls and Excel

ANSWERED
Regular Visitor

Downloading History of Dialed/Received/Missed calls and Excel

For those of you using Excel and Comcast phone, do you see the same behavior as below?

Comcast allows lists of calls dialed/received/missed to be downloaded, each as a tab separated text files.

If you change the extension on such a file to .xls, Excel will open the file.

However, the numbers are of the form minutes:seconds, so Excel thinks that the format is hh:mm, not mm:ss, where ss is ALWAYS 00. And the SUM function produces a value of 00:00.

If I prepend a 0: to each value, making Excel think that the format is h:mm:ss, then the SUM function produces a value, but the value is NOT correct.

For example, see below, in the leftmost column, the values are as given by Comcast, with a "0:" prepended. The other column was manually created by me.

The SUM of the leftmost column produces 1:21:00, indicating that 81 minutes were used.

The sum of the other column is 110.
Sumptin's not right.

     0:01:00 1.00
     0:01:00 1.00
     0:01:00 1.00
     0:01:00 1.00
     0:01:00 1.00
     0:01:00 1.00
     0:01:00 1.00
     0:02:00 2.00
     0:01:00 1.00
     0:02:00 2.00
     0:09:00 9.00
     0:01:00 1.00
     0:50:00 50.00
     0:01:00 1.00
     0:01:00 1.00
     0:01:00 1.00
      0:29:00 29.00
     0:01:00 1.00
     0:01:00 1.00
     0:01:00 1.00
     0:01:00 1.00
     0:01:00 1.00
     0:01:00 1.00
 
Note: I should not have to prepend  the "0:", rather, Comcast should be using values formatted as hh:mm:ss.


P.S. I'm doing this with Excel 2003.
Message Edited by HowardKaikow on 06-01-2009 06:45 PM
Accepted Solution

Re: Downloading History of Dialed/Received/Missed calls and Excel

Here's a solution using an Excel macro:

 

 

 

http://www.standards.com/index.html?FixTime

Message Edited by HowardKaikow on 06-20-2009 06:02 PM
View answer in context
Regular Visitor

Re: Downloading History of Dialed/Received/Missed calls and Excel

I found te same behavior using Excel 2007.
Regular Visitor

Re: Downloading History of Dialed/Received/Missed calls and Excel

Here's a solution using an Excel macro:

 

 

 

http://www.standards.com/index.html?FixTime

Message Edited by HowardKaikow on 06-20-2009 06:02 PM
New Poster

Re: Downloading History of Dialed/Received/Missed

Where to got to download History of received calls please?

once i get there, im fine. Thanks much

Frequent Visitor

Re: Downloading History of Dialed/Received/Missed

Save it as a CSV, edit it in notepad or other text editor and modify the phone number layout. It may contain colons hyphens or other mathematical operands.

 

You can "Replace All" colon to space. hyphen to space, etc etc.

 

Save it as csv file.

 

When you open it in Excel you have the ability to specify the format of each column imported. If you make qualify it as text it will treat the numbers as a letter and no math will be perfomed.

 

Then once in excel you can make it look nice with parentheses and hyphens.

 

good luck - I do this with almost every text download that is destined for excel.

Frequent Visitor

Re: Downloading History of Dialed/Received/Missed

My apologies - it's much more complicated as I see comcast only allows downloading in HTML format. Please disregard my instructions - "dumguy .... dumguy ...."

 

You CAN edit the html file and achieve the csv format but it's not that easy.

 

happy new year anyway.

New Poster

Re: Downloading History of Dialed/Received/Missed

Thank you..I have no problem using Excel, just need to know from where I find the info.