CUCM CDR Date & Time conversion.

Convert Call Manager CDR  DateTime in Excel.

Call Manager CDR normally exports DateTime field in Epoch format, it is just a reference number. To convert  it in to plane  readable format; here is a simple procedure.

First open CDR (normaly *.txt file)  in Excel > Select Delimeter as coma (CSV)

=(((E2+(3*3600))/86400)+25569)

E2 = cell reference
+3  = Timezone Offset
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.

Change column format to DateTime,and now it is done

Reference
http://en.wikipedia.org/wiki/Epoch_(reference_date)