Originally Posted by teamzr1
=B1/86400+"1"/1/70
B1 is where the raw data is


your quotes are wrong ... use "1/1/70" and not "1"/1/70

[Linked Image from sirdude.com]

^^ see my formula and where the quotes are wink