Date and Time setup

[Joe]

I work at a 24 hour job we take readings every hour. I want to have the date
autofill a cell as the current date but our sheet changes at 0700 every day.
So if the sheet is worked on at 0100 the date needs to be for the past day
starting at 0700, if the time for the current day changes to 0800 the cell
will display the new date. ie:
0100hrs = 4/18/06
0600hrs = 4/18/06
0800hrs = 4/19/06
etc...

 

[Ardus Petus]

=TODAY()-(A1<=TIME(7,0,0))*1

HTH

 

[JDBARNES63]

That looks good but does not work. Here is a better way that I need it
ti work..Joe

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