CDR

Unanswered Question
Apr 1st, 2009

In cdr it is like this

dateTimeOrigination

1238570992

How to change it to correct date and time in excel

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
mackersaffiniti Wed, 04/01/2009 - 01:38

Hi,

The time format is known as Unix time and is in the Epoch format:

http://en.wikipedia.org/wiki/Unix_time

For Excel you can use the formula:

/ 86400 + DateValue("1/1/1970")

Also remember that the time is based on whatever time format you installed the CUCM in so if it was GMT but the calls you are actaully looking for at GMT +1 you need to add 1 hours:

/ 86400 + DateValue("1/1/1970") +3600

,Best regards

Mackers

Actions

This Discussion