Converting time stamps in excel to dates -
i have large excel spread sheet has column of time stamps. know convert on date? there function can use? tried format cell date doesn't work. file 91,568 kb. if there simpler way great. i'm open ideas. thank in advance :) p.s. don't know programming languages use formula , set formatting desired time format: =(((column_id_here/60)/60)/24)+date(1970,1,1) source: http://www.bajb.net/2010/05/excel-timestamp-to-date/ tested in libreoffice