cdr export how to read the date

[trunkyccm]

HI, anyone come across this.

Exported cdr records show the date like this.

1183244005
1183244796
whilst when you view data within CAR you see the real date
like Aug 21, 2007 08:05:10 AM fir example. Any ideas how I can read this date fromt eh exported records in excel?

TIA

 

[HmmG3]

Those times are in epoch. I searched Excel and I couldn't find a function that would directly convert it. You can use this web site to do the conversions:

http://www.epochconverter.com/

 

[trunkyccm]

HmmG3, thsnks very much for the quick reply. You have to love cisco!