View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Mandeep Baluja Mandeep Baluja is offline
external usenet poster
 
Posts: 25
Default Guidance Required #01

=IF(A1<=TIME(12,0,0),"Morning Report",IF(A1<=TIME(13,0,0),"Afternoon Report","Evening Report"))

check this out !!!

1) in starting you have written if Cell A1 is equaly or between 12:00PM to 17:59 PM then CELL B1 should display Afternoon Report
2) Then you wrote Afternoon Status is only between 12:00hr till 13:00hrs.

Please stick to one parameter only

Regards,
mandeep baluja