Convert Excel Date to Unix Time Stamp (or Time Stamp to Excel Date)

This post will guide you how to convert a date string to a Unix time stamp in Excel. How do I convert excel date to Unix timestamp with a formula in Excel. How to convert Unix time stamp to an excel date string in Excel.

Convert Excel Date to Unix Time Stamp


If you want to convert the excel date string to unix time stamp in Excel, you can create a formula based on the DATE function.

For Example, you have a list of data that contain dates, and you want to convert each date to unix time stamp. You can use the following formula.

=(A1-DATE(1970,1,1))*86400

Type this formula into a blank cell and press Enter key and then drag the AutoFill handle from Cell B1 to B5.

convert date to unix timestamp1

Convert Unix Time Stamp to Excel Date


To convert a unix time stamp to an excel date string in Excel, you can use a formula based on the Date function. Like this:

=(((B1/60)/60)/24)+DATE(1970,1,1)

Type this formula into a cell and press Enter key, and then drag the AutoFill Handle from Cell C1 to C5.

convert date to unix timestamp2

Then you need to select the range of cells C1:C5, and right click on it, and select Format Cell from the popup menu list. And the Format Cell dialog will open. Click Date under Category list box, and then click OK button.

convert date to unix timestamp3

convert date to unix timestamp5

Let’s see the result:

 

convert date to unix timestamp4

Related Functions


  • Excel DATE function
    The Excel DATE function returns the serial number for a date.The syntax of the DATE function is as below:= DATE (year, month, day)…
Related Posts

Break ties with helper COUNTIF and column

Suppose you got a task to adjust the values that contain the ties; what would be your first attempt to break the ties of the given value? If you are wondering about doing this task manually, let me add that ...

Calculate Total Cost with Excel VLOOKUP Function

In today's article we will show you how to calculate the total cost for a given weight using the Excel VLOOKUP function. This function will help us to find the appropriate unit price for that weight and then we can ...

Excel Formulas To Calculate The Bond Valuation

Assume that you've been assigned a task of calculating bond valuation; so if you are new to Ms Excel or do not have much experience with it, then I am pretty sure about it that doing this task manually might ...

Calculate Cumulative Totals with Excel SUM Function

Today, through a simple example, we will show you how to use one of the most common-used Mathematical functions in excel, the SUM function, to add up the sum. In our daily life, we keep an account of what we ...

BMI Calculation Formula In Ms Excel

You might have come across a task in which you were assigned to make BMI calculations of the supplied numbers, and you may be looking for an efficient approach to accomplish this process rather than doing BMI calculations manually, by ...

Comments

So empty here ... leave a comment!

Leave a Reply

Sidebar