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.

References:

http://www.mrexcel.com/archive2/44100/51255.htm
http://www.peterabowen.com/?p=8

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • bodytext
  • del.icio.us
  • Facebook
  • Google
  • Live
  • Reddit
  • StumbleUpon
  • Technorati

Random Posts