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 […]
Continue reading…