Formula for converting a unix timestamp to a readable date?
I don't see a formula which will take a unix timestamp integer (i.e the number of seconds since 1/1/1970) and convert that to a readable date. anyone done this before?
Question marked as
Top-ranking reply
Moshe,
From your description of the unix timestamp, it seems that you just need to add the number of days represented by that number to Jan 1, 1970. Thus the formula as used in the demonstration below:
=B1+B2/24/60/60
pw
From your description of the unix timestamp, it seems that you just need to add the number of days represented by that number to Jan 1, 1970. Thus the formula as used in the demonstration below:
=B1+B2/24/60/60
pw