Converting XL date/times to Unix timestamps

  • Thread starter Thread starter whiz
  • Start date Start date
W

whiz

hello friends,

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


Thanks in advance
 
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)
 
Back
Top