SOLVED
Home

How to populate data by selecting codes.

%3CLINGO-SUB%20id%3D%22lingo-sub-711250%22%20slang%3D%22en-US%22%3EHow%20to%20populate%20data%20by%20selecting%20codes.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-711250%22%20slang%3D%22en-US%22%3E%3CP%3Ehow%20can%20I%20populate%20date%20by%20selecting%20codes%20like%20Ab%20Ac%20Ad%20AF%2C%20means%20when%20I%20select%20AB%20the%20automatically%20AB%20populates%20from%208%3AAM%20to%201%3A30%20PM%2C%20same%20way%20AC%20populate%2011%3A00%20to%204%3A%20pm%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CSTRONG%3ETime%20Slot%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E8%3A00%20AM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E8%3A30%20AM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E9%3A00%20AM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E9%3A30%20AM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E10%3A00%20AM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E10%3A30%20AM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E11%3A00%20AM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E11%3A30%20AM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E12%3A00%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E12%3A30%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E1%3A00%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E1%3A30%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E2%3A00%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E2%3A30%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E3%3A00%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E3%3A30%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E4%3A00%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E4%3A30%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E5%3A00%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E5%3A30%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E6%3A00%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E6%3A30%20PM%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CSTRONG%3EAB%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3EAB%3C%2FTD%3E%3CTD%3EAB%3C%2FTD%3E%3CTD%3EAB%3C%2FTD%3E%3CTD%3EAB%3C%2FTD%3E%3CTD%3EAB%3C%2FTD%3E%3CTD%3EAB%3C%2FTD%3E%3CTD%3EAB%3C%2FTD%3E%3CTD%3EAB%3C%2FTD%3E%3CTD%3EAB%3C%2FTD%3E%3CTD%3EAB%3C%2FTD%3E%3CTD%3EAB%3C%2FTD%3E%3CTD%3EAB%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CSTRONG%3EAC%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EAC%3C%2FTD%3E%3CTD%3EAC%3C%2FTD%3E%3CTD%3EAC%3C%2FTD%3E%3CTD%3EAC%3C%2FTD%3E%3CTD%3EAC%3C%2FTD%3E%3CTD%3EAC%3C%2FTD%3E%3CTD%3EAC%3C%2FTD%3E%3CTD%3EAC%3C%2FTD%3E%3CTD%3EAC%3C%2FTD%3E%3CTD%3EAC%3C%2FTD%3E%3CTD%3EAC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CSTRONG%3EAD%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3CTD%3EAD%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CSTRONG%3EAF%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3EAF%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-711250%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcelex%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-711436%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20populate%20data%20by%20selecting%20codes.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-711436%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F363636%22%20target%3D%22_blank%22%3E%40TariqRaza%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20like%3C%2FP%3E%0A%3CPRE%3E%3DIF(%0A%20%20%20(%24B6%3D%22AB%22)*(D%244%26gt%3B%3DTIME(8%2C0%2C0))*(D%244%26lt%3B%3DTIME(13%2C30%2C0))%2C%0A%20%20%20%24B6%2C%0A%20%20%20IF(%0A%20%20%20%20%20%20(%24B6%3D%22AC%22)*(D%244%26gt%3B%3DTIME(11%2C0%2C0))*(D%244%26lt%3B%3DTIME(16%2C30%2C0))%2C%0A%20%20%20%20%20%20%24B6%2C%0A%20%20%20%20%20%20IF(%0A%20%20%20%20%20%20%20%20%20(%24B6%3D%22AD%22)*(D%244%26gt%3B%3DTIME(11%2C0%2C0))*(D%244%26lt%3B%3DTIME(18%2C30%2C0))%2C%0A%20%20%20%20%20%20%20%20%20%24B6%2C%0A%20%20%20%20%20%20%20%20%20IF(%0A%20%20%20%20%20%20%20%20%20%20%20%20(%24B6%3D%22AF%22)*(D%244%26gt%3B%3DTIME(8%2C30%2C0))*(D%244%26lt%3B%3DTIME(14%2C30%2C0))%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%24B6%2C%22%22)%0A%20%20%20%20%20%20)%0A%20%20%20)%0A)%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-711502%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20populate%20data%20by%20selecting%20codes.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-711502%22%20slang%3D%22en-US%22%3EWow%2C%20its%20working.....%3A)%20Appreciated%20bro...hats%20Off%20!!!!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-711510%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20populate%20data%20by%20selecting%20codes.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-711510%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F363636%22%20target%3D%22_blank%22%3E%40TariqRaza%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
TariqRaza
New Contributor

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 AM8:30 AM9:00 AM9:30 AM10:00 AM10:30 AM11:00 AM11:30 AM12:00 PM12:30 PM1:00 PM1:30 PM2:00 PM2:30 PM3:00 PM3:30 PM4:00 PM4:30 PM5:00 PM5:30 PM6:00 PM6:30 PM
                        
AB ABABABABABABABABABABABAB          
AC       ACACACACACACACACACACAC     
AD       ADADADADADADADADADADADADADADADAD
AF  AFAFAFAFAFAFAFAFAFAFAFAFAF        
3 Replies
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,"")
      )
   )
)

 

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

@TariqRaza , you are welcome

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies