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