To remove the time portion in the date time stamp in a cell in Excel, We need to change the formatting of the cell in Excel 2016.
Format cells in Excel change the appearance of value without changing the value itself.
We will use the INT function along with format cell option.
Syntax of INT:
Let’s learn this by an example.
Select the B2 cell and use the shortcut key Ctrl + 1 to open the Format cell option.
Select Type of Date from Date option in Category.
We can still see the Time in the fx box of the B2 cell. We will use INT formula
Use the Formula in C2 cell
Now use Copy the value and Paste by values option in D2 cell to get the desired result.
To conclude, you can see in the above snapshot that the date format has been converted to show only the date without the time.
Use DATEVALUE Function to Remove Time From Date in Excel
The DATEVALUE function will get numeric value. This will exclude the time and only date will remain.
Use TIMEVALUE Function to extract Time From Date in Excel
The TIME VALUE function will get decimal part from timestamp. You, can use it to get only time.
you can subtract it from timestamp to get only date.
Hope you understood how to convert timestamp in Excel. You can perform these tasks in Excel 2013 and 2010. Find more articles on Format cells here. Please state your any unresolved query in the comment box below. We will help you.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.