Thread: If I am within the time specified..?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kashyap Kashyap is offline
external usenet poster
  
Posts: 131
Default If I am within the time specified..?
17:30 3:30 TRUE 4:46
18:00 5:00 TRUE 4:46
16:30 3:30 TRUE 4:46
11:30 22:30 FALSE 4:46

=IF(B2<A2,OR(A2<D2,B2D2),AND(A2<D2,B2D2))

in the above case, only 2nd should be true..


Reply With QuoteReply With Quote