CDR Date & Time conversion

[mightyking]

Hello All,

How can I convert the date & time in the CDR report to underestandable date and time? There used to be a tool for this matter, does anyone have that tool?

Thanks,

[Firdaush Ginowrie]

Hello,

you can translate the timestamp with this method:
1.Put the timestamp in cell a1.
2.In cell a2, enter =a1/86400+25569.
3.To apply a new format to this cell, right-click and choose Format cells >
Numbers > Custom. In the Type field, enter dd:mmm:yyyy hh:mm.
The output looks like this: 04 Apr 2001, 13:57
Regards,

Firdaush

[i.fouraki]

many many thanks!!!

[jmoreno@IBM]

UNIX Timestamp:

I know... Decade old issue, but here is the answer.

Do this in Excel:

1. Use this equation in a separate column.  =(((E2+(-8*3600))/86400)+25569)
   • E2 is our first cell of original CDR Date time. [Ex: 1520230703]
   • -8 is the Time Offset. I entered -8 to convert to PT.
   • 3600 is seconds in each hour.
   • 86400 is seconds in each day.
   • 25569 is because spreadsheet counts epoch from 1/1/1900 and most others start at 1/1/1970.
2. Press ENTER [on your keyboard]. Cell value should look something like this: 43164.5961.
3. Highlight new column or cell, right-click, and select Format Cells...
4. Use TIME or DATE format of your choosing.

[jitendra.shejwadkar]

Thank a lot for sharing the right information.

[jitendra.shejwadkar]

Thanks a lot for sharing right information.