digitalformula
New Member
- Joined
- Jul 28, 2010
- Messages
- 10
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 ...
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 ...