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
--
AP

"Joe" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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...

[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