Home » Posts

Convert Unix time stamp to Excel date

To convert a Unix timestamp to Excel's date format, you can use a formula based on the DATE function. In the example shown, the formula in C5 is: =(B5/86400)+DATE(1970,1,1)

April 14, 2025 · 1 min · 45 words · Jacob Ortiz

Table of Contents

Explanation

TheUnix time stamptracks time as a running count of seconds.

UTC is a universal measure of time that is independent of any particular time zone or daylight-saving time rules.

so you can see the value displayed as a time, atime formatneeds to be applied.

Excel formula: Convert Excel time to Unix time

Excel formula: Timesheet overtime calculation formula

Excel formula: Convert time to time zone

Excel formula: Get days, hours, and minutes between dates

Excel formula: Calculate hours between two times

Excel formula: Convert Excel time to decimal seconds

Excel DATE function

Explanation#

Explanation