Convert Excel Date/Time *TO* Unix timestamp

[digitalformula]

Hi all,

I've searched a lot on Google and on here and have found a ton of ways to convert a Unix timestamp *TO* an Excel Date/Time value but I need to do it the other way.

I've got 2 columns of values (about 9700 in total) - they're all in Excel Date/Time format and the cells have been formatted as such.

I need to convert all those values *TO* a Unix timestamp. For example, one of the cells has this:

25/07/2007 9:18:08 PM

Obviously that date isn't US format (I live in AU). Anyway, the Unix timestamp for that is 1185398288 (according to http://www.onlineconversion.com/unix_time.htm).

Obviously doing this manually for each cell isn't very productive.

Can anyone help me with a formula that can convert the existing Excel Date/Time *TO* a Unix timestamp?

Apologies for the emphasis but I've asked a ton of people and they all come back with how to convert the other way ...

 

[Richard Schollar]

Hi

Easy when you know how - here you go:

Excel Workbook
	A	B
15		01/01/1970
16	25/07/2007 21:18	1,185,398,288.00
Sheet2

Excel 2010

Cell Formulas
Range	Formula
B16	=(A16-$B$15)*86400

 

[digitalformula]

Hi

Easy when you know how - here you go:

Excel Workbook
	A	B
15		01/01/1970
16	25/07/2007 21:18	1,185,398,288.00
Sheet2

Excel 2010

Cell Formulas
Range	Formula
B16	=(A16-$B$15)*86400

You, my friend, are a freakin' life-saver. THANK YOU!