UCM Epoch dateTimeOrigination

UCM CDR’s, just in case I forget again;

Microsoft Excel =(A1 / 86400) + 25569 Format the result cell for date/time, the result will be in GMT time (A1 is the cell with the epoch number). For other time zones: =((A1 +/- time zone adjustment) / 86400) + 25569.

Formula:
=(A1/86400)+25569

 It gives you GMT time. If you would like to convert MST (in our case) time please use the below formula in excel.
=A2-TIME(7,0,0)

–Credit to

https://supportforums.cisco.com/t5/other-collaboration-voice-and/cdr-quot-datetimeorigination-quot-conversion-formula-in-excel/td-p/231546

Leave a comment

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

Are you human? * Time limit is exhausted. Please reload the CAPTCHA.