Back again, after some searching I found a more elegant way to make the conversion: =(((A3/60)/60)/24)+DATE(1970;1;1)-(8/24)
The -(8/24) is the GMT offset so if you are -7 GMT it would be -(7/24)
Reply | Reply To: How to convert CSV?
Back again, after some searching I found a more elegant way to make the conversion: =(((A3/60)/60)/24)+DATE(1970;1;1)-(8/24)
The -(8/24) is the GMT offset so if you are -7 GMT it would be -(7/24)