Open Office Calc: Convert a date to timestamp

Solution 1:

I've actually figured this one out, here is the answer:

=(C2 - DATEVALUE("1/1/1970"))*86400