Convert Epoch Time to Date in Excel (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Epoch time is the beginning point (date and time) from which computers measure their system time. For example, the epoch time in UNIX and POSIX-based operating systems is 00:00:00 UTC on Thursday, January 1, 1970. Sometimes, we face an epoch time dataset that is simply a tally of seconds counting from Unix Epoch time. However, we can not grasp just numbers since we utilize date, month, and year to count time. So, we’re going to convert epoch time to date excel


Download Practice Workbook

You can download the practice workbook from the following download button.


2 Simple Methods to Convert Epoch Time to Date in Excel

In cells B5:B16, we have a range of Unix timestamps to transform to dates.

a range of Unix timestamps


1. Using DATE Function and Format Cells Tool

We’ll first convert Unix timestamps to serial numbers using a formula with the DATE function, then use the date format to convert them to Excel dates.

📌 Steps:

  • Enter the following formula into cell C5 and hit Enter.
=(((B5/60)/60)/24)+DATE(1970,1,1)

Enter a formula

  • Now, drag the fill handle to fill the following cells in that column.

Using DATE function to convert epoch time to a serial number

  • After applying the formula, we will just copy the column to the adjacent column by Ctrl+C and Paste the Values into the Date columns.

Ctrl+C and Paste the Values

  • At this moment, we will select the serial no. and Format Cells… to convert those numbers to date.

 select the serial no. and Format Cells… to convert those numbers to date

  • Meanwhile, the Format Cells pop-up box will appear and we will select Date from Category, then 14-Mar-2012 from Type, and after that just click Ok.

 Format Cells pop-up

  • Subsequently, this data set in the below image is a representation of the conversion of the epoch time to date.

a dataset of the conversion of the epoch time to date

Read More: Convert Decimal Coordinates to Degrees Minutes Seconds in Excel


2. Combine DATE & TEXT Functions to Convert Epoch Time to Date

The TEXT function may also be used together with the DATE function to convert Unix timestamp information to Excel dates.

📌 Steps:

  • Click cell C5 and enter the following formula.
=TEXT((B5/86400)+DATE(1970,1,1),"m/d/yyyy")

Combine DATE & TEXT Functions to Convert Epoch Time to Date

  • Drag the fill handle and we will fill up the rest of the cells.

Drag the fill handle

Read More: Convert Time to Text in Excel (3 Effective Methods)


Conclusion

Follow these steps and stages to convert epoch time to date excel. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments section. For more such articles, visit our blog ExcelDemy.


Related Articles

Al Ikram Amit
Al Ikram Amit

Hello, I'm Amit, a BUET graduate with a passion for Excel. Currently, I work as an Excel & VBA Content Developer at ExcelDemy, contributing insightful articles to the blog. I enjoy sharing my knowledge with others and always look for opportunities to grow as an Excel expert. Feel free to reach out if you need assistance or want to discuss the latest trends in Excel. Let's excel together in the world of data manipulation and analysis!

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo