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.
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)
- Now, drag the fill handle to fill the following cells in that column.
- 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.
- At this moment, we will 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.
- Subsequently, this data set in the below image is a representation 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")
- Drag the fill handle and we will fill up the rest of the cells.
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
- How to Convert Minutes to Seconds in Excel (2 Quick Ways)
- Convert Hours to Days in Excel (6 Effective Methods)
- How to Convert Minutes to Hours and Minutes in Excel
- Convert Seconds to Hours and Minutes in Excel (4 Easy Methods)
- How to Convert Minutes to Tenths of an Hour in Excel (6 Ways)
- Convert Milliseconds to Seconds in Excel (2 Quick Ways)
- How to Convert Minutes to Days in Excel (3 Easy Methods)