Click Image to play tutorial:

In Call Manager, the CDR exports are in EPOCH time. Here is the formula to convert epoch time in a Call Manager CDR to a standard format in excel. After using the formula, you will need to format the cell for date and time.
=(((E2-(6*3600))/86400)+25569)
- E2 = cell reference
- 6 = Timezone Offset (this is Central Standard time)
- 3600 = Number of seconds in an hour
- 86400 = Number of seconds in a year
- 25569 = Excel hack because excel counts epoch from 1/1/1900 and most others start at 1/1/1970.
(more…)