Forum Discussion
How to remove time from date and time data in one cell
I have an Excel spreadsheet of 2000 records with the date DD MM YYYY and time HH:MM:SS in the same column and I want to remove the time detail from the column. Any suggestions how I might do this ?
To remove the time from a date and time data in one cell, you can use the following formula in Excel:
scss
Copy code
=INT(A1)
This formula extracts just the date part from the date and time value in cell A1 by converting the value to an integer, effectively removing the time.
scss
Copy code
=INT(A1)
This formula extracts just the date part from the date and time value in cell A1 by converting the value to an integer, effectively removing the time.