Date and Time Problem

[JDBARNES63]

I need to have the current day autofill a cell but it needs to be based on a time change at 0700 hrs. What I need is to be able to fill out my form, have the current date display in the cell but when the system clock changes to 0700 the date will roll up to the next day.


0100 hrs 4/18/06
0600 hrs 4/18/06
0900 hrs 4/19/06
2059 hrs 4/19/06
0100 hrs 4/19/06
0500 hrs 1/19/06
0705 hrs 1/20/06

[John James]

Based on your written description (not your table):

=NOW()+17/24

will move the time forward 17 hours so that 7am today turns over to tomorrow's date.