Unix time is also known as Epoch Time or POSIX time or Unix timestamp. The Unix time tracks the time as a running count of seconds , and it begins from January 1st, 1970. It is mostly used in operating systems or file formats. Here we are talking about how to convert the Excel time into Unix time quickly. Let’s begin. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- Use the below formula to convert a time in Excel’s format to a Unix timestamp.
=(A1-DATE(1970,1,1))*86400
Syntax Explanations:
- DATE – In Excel, the DATE function will combine three different values and returns them as a date.
- A1 – It represents the input time on your worksheet.
- Minus Operator (-) – This symbol will help to subtract any two values.
- *Multiplication (*) *– In this symbol will multiply any two values or numbers.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Example:
Refer to the below example image.
- First, we will enter the input times in Column B.
- Now we are going to convert them into a Unix time.
- Select any cell and type the above-given formula.
- After that, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.
Conclusion:
Hope you like this article on how to convert Excel time into Unix time. If you have any doubt regarding this article or have any other questions related to Excel, let me know in the comments section below. I reply to queries frequently!!
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
Top comments (0)