08-06-2008 09:06 AM - edited 03-15-2019 12:27 PM
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,
05-06-2015 08:55 AM
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
11-19-2018 03:53 AM
05-04-2018 11:12 AM - edited 05-04-2018 11:28 AM
UNIX Timestamp:
I know... Decade old issue, but here is the answer.
Do this in Excel:
06-19-2018 12:30 AM
Thank a lot for sharing the right information.
06-19-2018 12:32 AM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide