Convert Unix time stamp to Excel date
This tutorial show how to Convert Unix time stamp to Excel date using the example below. To convert a time in Excel’s format to a Unix time stamp, you can use a formula based on the DATE function. Formula =(A1/86400)+DATE(1970,1,1) Explanation of how this formula works In the example shown, the formula in C5 is: =(B5/86400)+DATE(1970,1,1) The Unix …