Home | Accuracy | DateTime in Excel | Time Zone Converter | PHP Epoch Converter | Epoch Time in Python | Unix Timestamp Generator | Convert Unix Epoch Timestamps Google Sheets Dates | Unix Timestamp Converter

How to Convert Unix Timestamp to DateTime in Excel

Unix timestamps represent the number of seconds since January 1, 1970, at 00:00:00 UTC. To convert a Unix timestamp into a readable date format in Excel, follow these simple steps:

Steps to Convert Unix Timestamp

  1. Open Excel: Start Microsoft Excel and open a new or existing workbook.
  2. Enter the Timestamp: In a cell, enter your Unix timestamp (e.g., 1633036800 in cell A1).
  3. Use the Conversion Formula: In another cell (e.g., B1), enter the formula: 

    =A1/86400 + DATE(1970,1,1)

    This formula converts the Unix timestamp to a readable date format.

  4. Format the Result: Right-click on the cell with the formula, select Format Cells, then choose Date to display it properly.
  5. Apply to Multiple Timestamps: Drag the fill handle from the corner of the cell to apply the formula to other timestamps.

Example Calculation

For instance, if you enter the following timestamps:

Your formulas in B1 and B2 should show:

By using this simple formula, you can easily convert Unix timestamps into readable dates in Excel, making data analysis more manageable.

Does Excel use epoch time?

Convert Unix Timestamp to DateTime in Excel

Epoch / UNIX time is the number of seconds that has elapsed since 1/1/1970. Excel calculates dates by using the number of days that have elapsed since 1/1/1900. Therefore you are able to convert from one to the other by converting from seconds to days, and then adding on the 70 years difference.

Verifying the Conversion

To ensure the conversion is accurate, you can use various methods:

  1. Online Unix Timestamp Converters: Websites like epochtiming.com and epochconverter.com allow you to enter a Unix timestamp and receive the corresponding date and time. Compare this with your Excel output.
  2. Use Excel Functions: You can check the converted date against known timestamps. For instance, the Unix timestamp 0 should convert to January 1, 1970. You can enter 0 in a cell and use the formula: 
    =0/86400 + DATE(1970,1,1)
    This should return the start date of the Unix epoch.
  3. Cross-Referencing: If you have access to a programming environment (like Python or JavaScript), you can convert the Unix timestamp using built-in functions and compare the results with your Excel conversions.

Example Calculation

Let us say you have the following Unix timestamps:

Input these timestamps in cells A1 and A2, and use the conversion formula in B1 and B2. After formatting the cells, you should see:

These results confirm the conversion is correct when compared with reliable online tools or programming outputs.

Conclusion

Converting Unix timestamps to readable date and time formats in Excel is a straightforward process using basic formulas. By applying the conversion formula and properly formatting your results, you can easily interpret timestamps for analysis. Verifying your conversions ensures accuracy, allowing you to work confidently with date and time data in Excel. Whether for data analysis, reporting, or record-keeping, mastering this conversion process is essential for anyone dealing with timestamps.

What Is The Current Unix Epoch Time?

The current UNIX EPOCH TIME is:

1771851132 seconds since January 1, 1970, 00:00:00 UTC.

Epoch Timing Tools & Articles

Epoch Timing - Unix Time Stamp - Epoch Converter

Get 20% OFF Website Hosting or VPS Plan #aff

Epoch Timing

About Us | Privacy Policy | Terms Of Use

Copyright © 1970-2026 epochtiming.com - All Rights Reserved.

Affiliate Disclosure: epochtiming.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, Amazon, Google, Hostinger, and the eBay Partner Network.