Formula to convert Epoch Timestamps to Readable Date in Excel

Writing by on Thursday, 20 of November , 2014 at 1:47 am

If you have several epoch times that you want to convert to human readable date then here’s a great post from spreadsheetpage.com on converting Unix Timestamps.

In a nutshell … you use the provided formula and then format to date.

For GMT
=(((A1/60)/60)/24)+DATE(1970,1,1)

For Pacific
=(((A1/60)/60)/24)+DATE(1970,1,1)+(-8/24)

Right Click the Cell –> Format Cells –> Date

Leave a comment

Category: Tips and Tricks

No Comments

No comments yet.

Leave a comment

You must be logged in to post a comment.

Shivdev Kalambi's Blog

Shivdev Kalambi is a Software Development Manager, previously a Principal Software Engineer at ArcSight/HP. With over 16 years' experience in software development, he's worked on several technologies and played different roles and contributed to all phases of projects. Non-tech activies include Ping-pong, Rock Climbing and Yoga at PG, Golf, Skiing, Swimming & a beer enthusiast.