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

Charles Hill · ‎01-28-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?

ckihlmire · ‎01-29-2009

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.