Today, I had the problem of converting a timestamp to a readable time format inside excel.  Not quite as easy as I would have hoped for, but the solution is fairly painless. In the excel column you wish to display the date, you need to place the following formula. =(((COLUMN_ID_HERE/60)/60)/24)+DATE(1970,1,1) You would then need to ...