Hi All,
I have the following date & time in a cell "01/07/2010 15:23"
If the time is greater than 12:00 I want the date to change to "02/07/2010 00:00" or just have "02/07/2010" show in another cell.
The cell format is set at general at the moment.
Is their an easy way a can do this please?
Thanks
I have the following date & time in a cell "01/07/2010 15:23"
If the time is greater than 12:00 I want the date to change to "02/07/2010 00:00" or just have "02/07/2010" show in another cell.
The cell format is set at general at the moment.
Is their an easy way a can do this please?
Thanks