Thread: If statement to compare time cell to a time
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] eloiza.davis@gmail.com is offline
external usenet poster
  
Posts: 1
Default If statement to compare time cell to a time
Don't suppose you want to help me as well?

=IF(AND(TIME(7,0,0)<=C93,E93=""),"FIRST",IF(AND(TI ME(7,0,0)<=C93,TIME(14,0,0)<=E93),"BOTH",IF(AND(TI ME(14,0,0)<=C93,E93=""),"SECOND","NA")))

The above is not working for the last condition - if C93 is later than 1400 and E93 is blank.

Thank you so much!!
Reply With QuoteReply With Quote