How to populate data by selecting codes.

[TariqRaza]

how can I populate date by selecting codes like Ab Ac Ad AF, means when I select AB the automatically AB populates from 8:AM to 1:30 PM, same way AC populate 11:00 to 4: pm

Time Slot

8:00 AM

8:30 AM

9:00 AM

9:30 AM

10:00 AM

10:30 AM

11:00 AM

11:30 AM

12:00 PM

12:30 PM

1:00 PM

1:30 PM

2:00 PM

2:30 PM

3:00 PM

3:30 PM

4:00 PM

4:30 PM

5:00 PM

5:30 PM

6:00 PM

6:30 PM

AB

AB

AB

AB

AB

AB

AB

AB

AB

AB

AB

AB

AB

AC

AC

AC

AC

AC

AC

AC

AC

AC

AC

AC

AC

AD

AD

AD

AD

AD

AD

AD

AD

AD

AD

AD

AD

AD

AD

AD

AD

AD

AF

AF

AF

AF

AF

AF

AF

AF

AF

AF

AF

AF

AF

AF

[#2 · Accepted solution]

@TariqRaza 

It's like

=IF(
   ($B6="AB")*(D$4>=TIME(8,0,0))*(D$4<=TIME(13,30,0)),
   $B6,
   IF(
      ($B6="AC")*(D$4>=TIME(11,0,0))*(D$4<=TIME(16,30,0)),
      $B6,
      IF(
         ($B6="AD")*(D$4>=TIME(11,0,0))*(D$4<=TIME(18,30,0)),
         $B6,
         IF(
            ($B6="AF")*(D$4>=TIME(8,30,0))*(D$4<=TIME(14,30,0)),
            $B6,"")
      )
   )
)

[#3]

Wow, its working.....:) Appreciated bro...hats Off !!!!!

[#4]

@TariqRaza , you are welcome