Converting Unix Epoch to Date in Excel
I ran into an interesting problem earlier today. I was using a CDR dump from our Cisco system. However, all of the datetime fields were represented as seconds. I knew right away that it used an epoch value. What I didn’t know is what the originating date was. Apparently, I was correct at my first guess. I guessed that it was using the standard Unix epoch value of 1/1/1970. Many applications, such as Microsoft Excel, use 1/1/1900. Since I wanted to represent the correct date and time in Excel, I began looking around for a formula. To my surprise, nothing … Continue reading Converting Unix Epoch to Date in Excel