jerrywoods
New Member
- Joined
- Feb 12, 2008
- Messages
- 12
c1 through bc1 column headings are 08:00 am thru 9:00 PM in increments of 15 minutes.
a1 & b1 headings are in, out respectively.
What I want is to check if time entered in a2 is >= to the time c1 and that time in a2 is <=c1.
If both statements are true, I want to enter 1 in c2 otherwise enter a zero.
this is the formula I entered and copied throughout the spreadsheet. =IF(AND($A2>=C1,$B2>=C1),0,1).
there are some problems. Would appreciate some assistance.
a1 & b1 headings are in, out respectively.
What I want is to check if time entered in a2 is >= to the time c1 and that time in a2 is <=c1.
If both statements are true, I want to enter 1 in c2 otherwise enter a zero.
this is the formula I entered and copied throughout the spreadsheet. =IF(AND($A2>=C1,$B2>=C1),0,1).
there are some problems. Would appreciate some assistance.