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…)