Converting XL date/times to Unix timestamps

[whiz]

hello friends,

Does anyone have a ready-made formula to convert XL
date/times(GMT+5:30) to Unix timestamps ?


Thanks in advance

 

[JE McGimpsey]

Unix timestamps are just elapsed seconds from 1/1/1970, so if the
date/time is in A1

=(A1-DATE(1970,1,1)-TIME(5,30,0))*86400

will give you a Unix datestamp relative to GMT (where 86400 is just 24
hours * 60 minutes/hr * 60 seconds/min)