Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
345
Views
5
Helpful
1
Replies

CDR

Eldho E Kuriakose
Level 3
Level 3

‎04-01-2009 01:13 AM - edited ‎03-15-2019 05:13 PM

In cdr it is like this

dateTimeOrigination

1238570992

How to change it to correct date and time in excel

Labels:
0 Helpful
1 Reply 1

mackersaffiniti
Level 1
Level 1

‎04-01-2009 01:38 AM

Hi,

The time format is known as Unix time and is in the Epoch format:

http://en.wikipedia.org/wiki/Unix_time

For Excel you can use the formula:

/ 86400 + DateValue("1/1/1970")

Also remember that the time is based on whatever time format you installed the CUCM in so if it was GMT but the calls you are actaully looking for at GMT +1 you need to add 1 hours:

/ 86400 + DateValue("1/1/1970") +3600

,Best regards

Mackers

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Customers Also Viewed These Support Documents