Hi Bob,
Just got back in the office. The formula below
is valid, but it returns everything as true. I need to
integrate the date with the time to work properly. Today
is 1-21-05 and it is 7:51AM. I need it to return a true
for all cells from 1-20-05 7:00AM to 1-21-05 7:00AM
preferably without explicitly putting in the date/time.
How do I work the date part into the format?

Mike
-----Original Message-----
Mike,

If I understand correctly, --"07:00:00" can be used to
test fro 7:00AM. E,g

=IF(A1--"07:00:00", etc.

Does that help?

--
HTH

Bob Phillips

"MIke K" wrote in
message
...
Oh wise ones,
I run a report in the morning which calls
cells from yesterday morning at 7:00AM until now- if now
is before 7:00AM. Or if now is past 7:00AM, from
yesterday
at 7:00AM until today at 7:00AM. I can do NOW and NOW-1
but I can't figure out the 7:00AM absolute time. Help is
much appreciated.

Mike


.