hi there, I have a problem with a time sheet not changing the date at midnight.
example:
A B
18/06/2012 23:45:00
18/06/2012 23:55:00
I want the next cell on Column A to turn into the new date since it is past midnight.