Home

What would be the formula:-

%3CLINGO-SUB%20id%3D%22lingo-sub-711982%22%20slang%3D%22en-US%22%3EWhat%20would%20be%20the%20formula%3A-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-711982%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Every%20One.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyone%20to%20guide%20me%2C%20what%20would%20be%20the%20formula%20in%20this%20case%2C%20the%20time%20slot%20what%26nbsp%3B%20select%20%22from%20and%20to%22%20corresponding%20time%20slots%20fill%20with%20%22x%22%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3Esame%20way%20is%20two%20time%20slots%20(Split%20timings)%20it%20should%20also%20be%20selected%20in%20two%20slots%20as%20depicted%20below.%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EFrom%3C%2FTD%3E%3CTD%3ETo%3C%2FTD%3E%3CTD%3EFrom%3C%2FTD%3E%3CTD%3ETo%3C%2FTD%3E%3CTD%3E6%3A00%20AM%3C%2FTD%3E%3CTD%3E6%3A30%20AM%3C%2FTD%3E%3CTD%3E7%3A00%20AM%3C%2FTD%3E%3CTD%3E7%3A30%20AM%3C%2FTD%3E%3CTD%3E8%3A00%20AM%3C%2FTD%3E%3CTD%3E8%3A30%20AM%3C%2FTD%3E%3CTD%3E9%3A00%20AM%3C%2FTD%3E%3CTD%3E9%3A30%20AM%3C%2FTD%3E%3CTD%3E10%3A00%20AM%3C%2FTD%3E%3CTD%3E10%3A30%20AM%3C%2FTD%3E%3CTD%3E11%3A00%20AM%3C%2FTD%3E%3CTD%3E11%3A30%20AM%3C%2FTD%3E%3CTD%3E12%3A00%20PM%3C%2FTD%3E%3CTD%3E12%3A30%20PM%3C%2FTD%3E%3CTD%3E1%3A00%20PM%3C%2FTD%3E%3CTD%3E1%3A30%20PM%3C%2FTD%3E%3CTD%3E2%3A00%20PM%3C%2FTD%3E%3CTD%3E2%3A30%20PM%3C%2FTD%3E%3CTD%3E3%3A00%20PM%3C%2FTD%3E%3CTD%3E3%3A30%20PM%3C%2FTD%3E%3CTD%3E4%3A00%20PM%3C%2FTD%3E%3CTD%3E4%3A30%20PM%3C%2FTD%3E%3CTD%3E5%3A00%20PM%3C%2FTD%3E%3CTD%3E5%3A30%20PM%3C%2FTD%3E%3CTD%3E6%3A00%20PM%3C%2FTD%3E%3CTD%3E6%3A30%20PM%3C%2FTD%3E%3CTD%3E7%3A00%20PM%3C%2FTD%3E%3CTD%3E7%3A30%20PM%3C%2FTD%3E%3CTD%3E8%3A00%20PM%3C%2FTD%3E%3CTD%3E8%3A30%20PM%3C%2FTD%3E%3CTD%3E9%3A00%20PM%3C%2FTD%3E%3CTD%3E9%3A30%20PM%3C%2FTD%3E%3CTD%3E10%3A00%20PM%3C%2FTD%3E%3CTD%3E10%3A30%20PM%3C%2FTD%3E%3CTD%3E11%3A00%20PM%3C%2FTD%3E%3CTD%3E11%3A30%20PM%3C%2FTD%3E%3CTD%3E8%3A00%20AM%3C%2FTD%3E%3CTD%3E8%3A30%20AM%3C%2FTD%3E%3CTD%3E9%3A00%20AM%3C%2FTD%3E%3CTD%3E9%3A30%20AM%3C%2FTD%3E%3CTD%3E10%3A00%20AM%3C%2FTD%3E%3CTD%3E10%3A30%20AM%3C%2FTD%3E%3CTD%3E11%3A00%20AM%3C%2FTD%3E%3CTD%3E11%3A30%20AM%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E8%3A30%20AM%3C%2FTD%3E%3CTD%3E5%3A30%20AM%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%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%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%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%3E8%3A30%20AM%3C%2FTD%3E%3CTD%3E1%3A00%20PM%3C%2FTD%3E%3CTD%3E5%3A30%20AM%3C%2FTD%3E%3CTD%3E10%3A30%20AM%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%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%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%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%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%3E9%3A30%20AM%3C%2FTD%3E%3CTD%3E5%3A30%20AM%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%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%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%3E9%3A30%20AM%3C%2FTD%3E%3CTD%3E1%3A00%20PM%3C%2FTD%3E%3CTD%3E7%3A30%20AM%3C%2FTD%3E%3CTD%3E11%3A30%20AM%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%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%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%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%3C%2FTD%3E%3CTD%3Ex%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-711982%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-714548%22%20slang%3D%22en-US%22%3ERe%3A%20What%20would%20be%20the%20formula%3A-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-714548%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%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20please%20clarify%20the%20logic.%26nbsp%3BIn%20your%20sample%20in%20row%202%20you%20have%20from%208%3A30AM%20to%205%3A30AM%20(thus%20over%20the%20night)%2C%20but%20you%20stop%20marking%20at%201%3A30.%20Similar%20in%20other%20rows.%3C%2FP%3E%0A%3CP%3EAnd%20From%2FTo%20in%20columns%20C%20and%20D%20mean%20next%20day%20time%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
TariqRaza
New Contributor

Hi Every One.

 

Is there anyone to guide me, what would be the formula in this case, the time slot what  select "from and to" corresponding time slots fill with "x"

same way is two time slots (Split timings) it should also be selected in two slots as depicted below.

FromToFromTo6:00 AM6:30 AM7:00 AM7:30 AM8: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 PM7:00 PM7:30 PM8:00 PM8:30 PM9:00 PM9:30 PM10:00 PM10:30 PM11:00 PM11:30 PM8:00 AM8:30 AM9:00 AM9:30 AM10:00 AM10:30 AM11:00 AM11:30 AM
8:30 AM5:30 AM       xxxxxxxxxxx                            
8:30 AM1:00 PM5:30 AM10:30 AM     xxxxxxxxxx        xxxxxxxxxxx          
9:30 AM5:30 AM         xxxxxxxxxxxxxxxxx                    
9:30 AM1:00 PM7:30 AM11:30 AM       xxxxxxxx            xxxxxxxxx        
1 Reply

@TariqRaza 

 

Could you please clarify the logic. In your sample in row 2 you have from 8:30AM to 5:30AM (thus over the night), but you stop marking at 1:30. Similar in other rows.

And From/To in columns C and D mean next day time?

 

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
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies