View original (French)

Remove the time from a date

Solved
Murielle!! Posted messages 76 Status Membre -  
 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

7 réponses

Réponse 1 / 7
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
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
66
GG
 
Thank you so much! You saved my morning.
0
Kozam
 
Thank you very much for your help :)
0