Hi,
I have a database which was populated with UNIX timestamps as Integer values.
Can anybody tell me how to convert this to OO formats?
Thanks
Klaus
=J3/86400+DATEVALUE("1/1/1970")
=A2/86400+25569
1565146800000 07/13/-13969 00:00:00
As we've said in data processing for 50+ years: Garbage in; garbage out. Your "UNIX timestamp" is bogus. Current UNIX timestamps are about 1½ billion, ten decimal digits. Your value 1,565,146,800,000 (13 decimal digits, about 1½ trillion) would be the number of milliseconds since 1970-01-01, not the number of seconds. If this is the data you have, use formula =cell*TIMEVALUE("0:00.001")+DATEVALUE("1970-01-01") or =cell/86400000+25569.bns002.OOConfused wrote:I'm getting a negaive year, and no time.1565146800000 07/13/-13969 00:00:00
Users browsing this forum: No registered users and 13 guests