Date & Time (add a day)

[indy1982]

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

 

[VoG]

Try

=IF(MOD(A1,1)>0.5,INT(A1+1),INT(A1))

and format as Date.

 

[indy1982]

Thanks mate that worked a treat!

 

[indy1982]

Just one other very quick query if the time is bang on "01/07/2010 12:00" is it possible to add a day.

At the moment only changes to "02/07/2010" if the time is set at "01/07/2010 12:01"

Thankyou

 

[VoG]

Yep

=IF(MOD(A1,1)>=0.5,INT(A1+1),INT(A1))

 

[indy1982]

Thankyou

 

[VoG]

Actually I have over-complicated this

=ROUND(A1,0)