Search results

OMG! Shamimarita! You are a saint! I divided the epoch by 1,000 and suddenly my formula worked! I was actually using this formula, which I got off the exceldemy website: =(((I2/60)/60)/24)+DATE(1970,1,1) I'm good now and thank you very much! This will be extremely helpful - when I tried...

I’m trying to convert epoch numbers to date/time and following the instructions in this website, all I get is an infinite row of #’s. I copied the formula, changed the cell reference to my worksheet, copied the value of the output to a new column, tried to format - output was ################...