Remove the time from a date
Solved
Murielle!!
Posted messages
76
Status
Member
-
demaumel -
demaumel -
Hello,
I would like to know how to remove the time associated with the date in Excel, please.
Here is an example of a series.
11/01/2013 00:00
11/01/2013 00:15
11/01/2013 00:30
11/01/2013 00:45
11/01/2013 01:00
11/01/2013 01:15
11/01/2013 01:30
11/01/2013 01:45
11/01/2013 02:00
11/01/2013 02:15
11/01/2013 02:30
11/01/2013 02:45
11/02/2013 00:00
11/02/2013 00:15
11/02/2013 00:30
11/02/2013 00:45
11/02/2013 01:00
11/02/2013 01:15
11/02/2013 01:30
11/02/2013 01:45
11/02/2013 02:00
11/02/2013 02:15
11/02/2013 02:30
11/02/2013 02:45
11/02/2013 03:00
11/02/2013 03:15
11/02/2013 03:30
Thank you for your help
Configuration: Windows 7 / Internet Explorer 8.0
I would like to know how to remove the time associated with the date in Excel, please.
Here is an example of a series.
11/01/2013 00:00
11/01/2013 00:15
11/01/2013 00:30
11/01/2013 00:45
11/01/2013 01:00
11/01/2013 01:15
11/01/2013 01:30
11/01/2013 01:45
11/01/2013 02:00
11/01/2013 02:15
11/01/2013 02:30
11/01/2013 02:45
11/02/2013 00:00
11/02/2013 00:15
11/02/2013 00:30
11/02/2013 00:45
11/02/2013 01:00
11/02/2013 01:15
11/02/2013 01:30
11/02/2013 01:45
11/02/2013 02:00
11/02/2013 02:15
11/02/2013 02:30
11/02/2013 02:45
11/02/2013 03:00
11/02/2013 03:15
11/02/2013 03:30
Thank you for your help
Configuration: Windows 7 / Internet Explorer 8.0
7 answers
-
Hello,
in a free column:
=INT(A2*1)
to be copied downwards, then set the desired format.
Finish with a special copy-paste values to remove the link to the original column to be deleted.
Eric
--
In addition to thank you (yes, that’s a thing!!!), remember to mark as resolved (at the top next to your title) when applicable. Thank you
