Date and Time Problem

J

JDBARNES63

I need to have the current day autofill a cell but it needs to be base
on a time change at 0700 hrs. What I need is to be able to fill out m
form, have the current date display in the cell but when the syste
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/0
 
J

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.
 
Top