=IF(and((B2-INT(B2))=TIME(8,0,0),(B2-INT(B2))<TIME(18,0,0)),"Y","N").

"Sharon19" wrote:

Thanks that works. Now if they also want to check to make sure it is = 8:00
a.m.and before 6:00 p.m. how would you write this. I am thinking using the
AND or the OR but I am not sure.

"bpeltzer" wrote:

In C2: =IF((B2-INT(B2))=TIME(8,0,0),"Y","N"). This will put a Y in C2 if
the end TIME in B2 is 8am or later. Fill this formula down into each row of
your data.
--Bruce

"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!