Try the below formula which will check the time portion of the data/time that
is in column B.

=IF(MOD(B1,1)0.33333,"Y","N")

There may be an easier way but this appears to work.

Thanks,
Bill Horton

"Sharon19" wrote:

I need help with the following functions for dates. In Column A I have a
start date (including time) and in Column B I have the end date (including
time). I have been tasked with finding out if the end time is past 8:00 a.m.
each day. If the end time is past 8:00 a.m. I must place a €œY€� in Column C
or an €œN€� in Column C.
This out my data looks:

Column A Column B
Start Time End Time
10/20/2005 23:00 10/20/2005 23:53
10/20/2005 10:00 10/21/2005 8:30
How do I check the time with the date being in the beginning of this data?
The date maybe the same day or could be the next day.

Thanks!