Browse By

Convert Cisco CDR EPOCH Date and Time

Convert Cisco CDR EPOCH Date and Time

In part 1, we have seen the configuration and creation of the CDR Report. Now lets go more deeper and further.
In Part 1, did you realize that the CDR Report which was shown, the time was in Unix EPOCH time format. Now to convert it in readable format, you need to do the following.

Let us take again the previous report were the time was not converted in readable format.

CallingPartyCalledPartyDurationDateandTime

  • Go to Column E and Enter the row E1 as Date and Time
  • Go to Column E and enter the following formula in E2    =D2/86400+DATE(1970,1,1)    and drag E2 till E20

CallingPartyCalledPartyDurationDateandTime_1

  • Select Column E and Right Click and Select Format Cells
  • Select Date
  • Select appropriate Sample based on your requirement, i would like to select MM/DD/YY HH:SS
  • Click on OK and here you go. You have now converted the Time successfully.

CallingPartyCalledPartyDurationDateandTime_2

Note: – The above time format is given in GMT Format. If you want to convert the timezone in your local format, please follow the below chart.
For example :- If you need to convert the time from GMT to IST the formula would be
=(((D2+(19800))/86400)+25569)

How i calculated the above?
IST Time would be GMT +5:30
Now convert 5 hours + 30 minutes in minutes= 330 minutes
Now convert 330 minutes in seconds = 330*60 = 19800 seconds
Follow the below chart.
Date&Time-all-zone

One thought on “Convert Cisco CDR EPOCH Date and Time”

  1. umesh says:

    thanks for this post

Leave a Reply

Your email address will not be published. Required fields are marked *

Approved
Claudio Quiroz Cabello

Electrical Engineer CCNA Collaboration CCNA Voice CCNA R&S. I'm Electrical Engineer and I work like Support Engineer for a Telephony Service Provider Company. Before that I had position like Pre-Sale Engineer about small and medium multivendor telephony solutions. I have 5 years of experience working in Telephony Multivendor Projects. I am also 3 years of experience working in Support and implementation about Cisco Collaboration platforms: UCS server, UCM, Cisco Unity, Presence Server, Jabber, Gateway. Support Community is most useful in finding design, implementation and support tricks and shortcuts that greatly help me in my daily activities. If you need to contact me, please you can writte me.

Approved
Kanishka Singh

CCNA Routing and Switching
Am a technology enthusiast. I work in network support providing support with implementation, maintaining and precisely troubleshooting the infra.
Realm of collaboration makes me want to learn and face new challenges more and more.

Show Buttons
Hide Buttons