View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] diamond.prabhjot@gmail.com is offline
external usenet poster
 
Posts: 1
Default If statement to compare time cell to a time

I need to use IF command with Time like
If A1 is lens then 6:00 hours the B1 to print Half Day else Full day

kindly guide the solution