Formula to convert Epoch Timestamps to Readable Date in Excel
Writing by shivdev 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
- Add this post to
- Del.icio.us -
- Digg -
- -
- Tweet -
-
-
No Comments
No comments yet.
Leave a comment
You must be logged in to post a comment.
