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.


 It gives you GMT time. If you would like to convert MST (in our case) time please use the below formula in excel.

–Credit to


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.