Monday, October 28, 2013

Excel formula to convert a Unix timestamp to a readable data and time

=(((A1/60)/60)/24)+DATE(1970,1,1)+(+10/24)


http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/

No comments: