Converting Unix timestamp to date and time in Excel

I had a weird issue today, at work, where I was given a Microsoft Excel file. I had unix timestamp in one column and I was required to change them all into normal date and time

Using excel, its pretty easy. Suppose that the unix timestamp is in column B, do this


Where B is the column name, 2 is the row number. Diving by 60/60/24 gives the days. Adding DATE because unix timestamp runs from 1970. “-5” is the GMT/UTC difference that you want to apply to the conversion

Now that you have a floating value as DAYS, right click on the cell, choose FORMAT CELL and choose DATE to display date and/or time.

However, If you only want to display time without the date part, choose TIME instead

One thought on “Converting Unix timestamp to date and time in Excel

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.