cdr report on ccm 6.1(2) shows call times in utc

Unanswered Question
Jan 28th, 2009

Cdr report on ccm6.1(2) shows the call times in utc time instead of local time. How can I change it to reflect local time?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
ckihlmire Thu, 01/29/2009 - 09:23

I have yet been able to find a way to change it as well. When pulling together reports I am sorting out just the data I need from the CDR and dumping it into Excel.

I have found an Excel formula that will convert the UTC time for you. The formula to convert to EST that I use is =(A3/86400 + 25569)-5/24. For the date the formula I use is =A3/86400 + 25569. A3 is referring to column that has the UTC time Stamp.

Typically I will set column B as the Date and column C as the time. You will need to format your date column as MM/DD/YYYY. The time column will also need to be set. I use HH:MM:SS AM/PM because my end users don't understand 24hr time.

Hope this helps some.


This Discussion