Convert Excel Date/Time *TO* Unix timestamp

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 ...
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Hi

Easy when you know how - here you go:
Excel Workbook
AB
1501/01/1970
1625/07/2007 21:181,185,398,288.00
Sheet2
Excel 2010
Cell Formulas
RangeFormula
B16=(A16-$B$15)*86400
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,287
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top