Converting normal time to Epoch time format using excel

Colombo

Board Regular
Joined
Apr 21, 2003
Messages
54
I'm working on converting some databases. One has entries with normal human readable time format, the other uses the unix epoch time format.

Is there a function or vba code that I can use in excel to convert the normal time format to epoch time?

I've got a thousand or so entries, so it would be nice to find a way to do this on a large scale.

Thanks

Josh
 
If you put that formula in B1 then you should be able to "drag" it down. Put the formula in cell and then place the cursor on the bottom right of the cell until you see a black "+" - that's the "fill-handle".

Then you can do one of two things, either hold down the left mouse and drag down as far as you need or you can just double-click left mouse and the formula should automatically fill down as far as you have continuous data in an adjacent column.
 
Upvote 0

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Thank you so much that is very helpful. I did not know you could auto fill the columns with a double click, that will help me heaps.
 
Upvote 0
How can I make this a format cell button or macro?
Where I would not need to remember this formula?
Or add an additional column?

I would like to convert: epoch time to dddd, mmmm dd, yyyy hh:mm:ss

Thank you :)
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

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