@Joe4 good idea!
Any ideas on "tricking" excel to think that 11pm is "earlier" than 12am?
I tried this but failed: =IF(AND(T2=TIME(23,0,0),S2=TIME(0,0,0)),"EARLIER",IF(T2=U2,"SAME",IF(T2<u2,"earlier",if(t2>U2,"LATER"))))
See row 6 for example...
| A | R | S | T | U | V |
---|
Store | Winter Hours TY Close Time | Current Summer Hours Close Time | MOD Winter Hours TY Close Time | MOD Current Summer Hours Close Time | TIME CHANGE THIS WINTER TO THIS SUMMER | |
SAME | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
SAME | | | | | | |
EARLIER | | | | | | |
LATER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
LATER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
LATER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
LATER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
LATER | | | | | | |
SAME | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
SAME | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
LATER | | | | | | |
LATER | | | | | | |
EARLIER | | | | | | |
LATER | | | | | | |
LATER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
LATER | | | | | | |
EARLIER | | | | | | |
EARLIER | | | | | | |
LATER | | | | | | |
LATER | | | | | | |
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]6004[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]11:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"]6005[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"]6006[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]8[/TD]
[TD="align: right"]6007[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"]6008[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"]6009[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]11[/TD]
[TD="align: right"]6010[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]12[/TD]
[TD="align: right"]6011[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]13[/TD]
[TD="align: right"]6012[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]9:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]9:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]14[/TD]
[TD="align: right"]6013[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"]6014[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]16[/TD]
[TD="align: right"]6015[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]17[/TD]
[TD="align: right"]6017[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]18[/TD]
[TD="align: right"]6018[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]19[/TD]
[TD="align: right"]6019[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]9:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]9:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: center"]20[/TD]
[TD="align: right"]6021[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]21[/TD]
[TD="align: right"]6022[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]22[/TD]
[TD="align: right"]6023[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]10:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]23[/TD]
[TD="align: right"]6024[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]24[/TD]
[TD="align: right"]6025[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]25[/TD]
[TD="align: right"]6026[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]26[/TD]
[TD="align: right"]6027[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]27[/TD]
[TD="align: right"]6028[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]28[/TD]
[TD="align: right"]6029[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]29[/TD]
[TD="align: right"]6031[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]30[/TD]
[TD="align: right"]6032[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]31[/TD]
[TD="align: right"]6033[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]32[/TD]
[TD="align: right"]6034[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]33[/TD]
[TD="align: right"]6035[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]34[/TD]
[TD="align: right"]6036[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]35[/TD]
[TD="align: right"]6037[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]36[/TD]
[TD="align: right"]6038[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]37[/TD]
[TD="align: right"]6050[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]38[/TD]
[TD="align: right"]6051[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]39[/TD]
[TD="align: right"]6052[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]1:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]1:00:00 AM[/TD]
[TD="align: center"]40[/TD]
[TD="align: right"]6053[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]41[/TD]
[TD="align: right"]6054[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]42[/TD]
[TD="align: right"]6055[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]43[/TD]
[TD="align: right"]6057[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]44[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]45[/TD]
[TD="align: right"]6059[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: center"]46[/TD]
[TD="align: right"]6060[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: center"]47[/TD]
[TD="align: right"]6061[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]48[/TD]
[TD="align: right"]6062[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]49[/TD]
[TD="align: right"]6063[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]10:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: center"]50[/TD]
[TD="align: right"]6064[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]1:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]1:00:00 AM[/TD]
</tbody>
Weekday_Sales
[TABLE="width: 85%"]
<tbody>[TR]
[TD]
Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S2[/TH]
[TD="align: left"]=VLOOKUP(
A2,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T2[/TH]
[TD="align: left"]=MOD(
R2,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U2[/TH]
[TD="align: left"]=MOD(
S2,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V2[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T2=TIME(23,0,0),S2=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T2=U2,"SAME",IF(
T2<u2,"earlier",if(T2>U2,"LATER"</u2,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S3[/TH]
[TD="align: left"]=VLOOKUP(
A3,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T3[/TH]
[TD="align: left"]=MOD(
R3,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U3[/TH]
[TD="align: left"]=MOD(
S3,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V3[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T3=TIME(23,0,0),S3=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T3=U3,"SAME",IF(
T3<u3,"earlier",if(T3>U3,"LATER"</u3,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S4[/TH]
[TD="align: left"]=VLOOKUP(
A4,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T4[/TH]
[TD="align: left"]=MOD(
R4,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U4[/TH]
[TD="align: left"]=MOD(
S4,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V4[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T4=TIME(23,0,0),S4=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T4=U4,"SAME",IF(
T4<u4,"earlier",if(T4>U4,"LATER"</u4,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S5[/TH]
[TD="align: left"]=VLOOKUP(
A5,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T5[/TH]
[TD="align: left"]=MOD(
R5,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U5[/TH]
[TD="align: left"]=MOD(
S5,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V5[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T5=TIME(23,0,0),S5=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T5=U5,"SAME",IF(
T5<u5,"earlier",if(T5>U5,"LATER"</u5,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S6[/TH]
[TD="align: left"]=VLOOKUP(
A6,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T6[/TH]
[TD="align: left"]=MOD(
R6,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U6[/TH]
[TD="align: left"]=MOD(
S6,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V6[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T6=TIME(23,0,0),S6=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T6=U6,"SAME",IF(
T6<u6,"earlier",if(T6>U6,"LATER"</u6,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S7[/TH]
[TD="align: left"]=VLOOKUP(
A7,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T7[/TH]
[TD="align: left"]=MOD(
R7,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U7[/TH]
[TD="align: left"]=MOD(
S7,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V7[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T7=TIME(23,0,0),S7=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T7=U7,"SAME",IF(
T7<u7,"earlier",if(T7>U7,"LATER"</u7,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S8[/TH]
[TD="align: left"]=VLOOKUP(
A8,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T8[/TH]
[TD="align: left"]=MOD(
R8,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U8[/TH]
[TD="align: left"]=MOD(
S8,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V8[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T8=TIME(23,0,0),S8=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T8=U8,"SAME",IF(
T8<u8,"earlier",if(T8>U8,"LATER"</u8,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S9[/TH]
[TD="align: left"]=VLOOKUP(
A9,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T9[/TH]
[TD="align: left"]=MOD(
R9,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U9[/TH]
[TD="align: left"]=MOD(
S9,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V9[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T9=TIME(23,0,0),S9=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T9=U9,"SAME",IF(
T9<u9,"earlier",if(T9>U9,"LATER"</u9,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S10[/TH]
[TD="align: left"]=VLOOKUP(
A10,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T10[/TH]
[TD="align: left"]=MOD(
R10,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U10[/TH]
[TD="align: left"]=MOD(
S10,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V10[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T10=TIME(23,0,0),S10=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T10=U10,"SAME",IF(
T10<u10,"earlier",if(T10>U10,"LATER"</u10,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S11[/TH]
[TD="align: left"]=VLOOKUP(
A11,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T11[/TH]
[TD="align: left"]=MOD(
R11,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U11[/TH]
[TD="align: left"]=MOD(
S11,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V11[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T11=TIME(23,0,0),S11=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T11=U11,"SAME",IF(
T11<u11,"earlier",if(T11>U11,"LATER"</u11,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S12[/TH]
[TD="align: left"]=VLOOKUP(
A12,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T12[/TH]
[TD="align: left"]=MOD(
R12,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U12[/TH]
[TD="align: left"]=MOD(
S12,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V12[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T12=TIME(23,0,0),S12=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T12=U12,"SAME",IF(
T12<u12,"earlier",if(T12>U12,"LATER"</u12,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S13[/TH]
[TD="align: left"]=VLOOKUP(
A13,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T13[/TH]
[TD="align: left"]=MOD(
R13,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U13[/TH]
[TD="align: left"]=MOD(
S13,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V13[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T13=TIME(23,0,0),S13=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T13=U13,"SAME",IF(
T13<u13,"earlier",if(T13>U13,"LATER"</u13,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S14[/TH]
[TD="align: left"]=VLOOKUP(
A14,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T14[/TH]
[TD="align: left"]=MOD(
R14,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U14[/TH]
[TD="align: left"]=MOD(
S14,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V14[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T14=TIME(23,0,0),S14=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T14=U14,"SAME",IF(
T14<u14,"earlier",if(T14>U14,"LATER"</u14,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S15[/TH]
[TD="align: left"]=VLOOKUP(
A15,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T15[/TH]
[TD="align: left"]=MOD(
R15,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U15[/TH]
[TD="align: left"]=MOD(
S15,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V15[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T15=TIME(23,0,0),S15=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T15=U15,"SAME",IF(
T15<u15,"earlier",if(T15>U15,"LATER"</u15,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S16[/TH]
[TD="align: left"]=VLOOKUP(
A16,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T16[/TH]
[TD="align: left"]=MOD(
R16,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U16[/TH]
[TD="align: left"]=MOD(
S16,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V16[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T16=TIME(23,0,0),S16=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T16=U16,"SAME",IF(
T16<u16,"earlier",if(T16>U16,"LATER"</u16,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S17[/TH]
[TD="align: left"]=VLOOKUP(
A17,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T17[/TH]
[TD="align: left"]=MOD(
R17,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U17[/TH]
[TD="align: left"]=MOD(
S17,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V17[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T17=TIME(23,0,0),S17=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T17=U17,"SAME",IF(
T17<u17,"earlier",if(T17>U17,"LATER"</u17,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S18[/TH]
[TD="align: left"]=VLOOKUP(
A18,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T18[/TH]
[TD="align: left"]=MOD(
R18,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U18[/TH]
[TD="align: left"]=MOD(
S18,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V18[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T18=TIME(23,0,0),S18=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T18=U18,"SAME",IF(
T18<u18,"earlier",if(T18>U18,"LATER"</u18,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S19[/TH]
[TD="align: left"]=VLOOKUP(
A19,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T19[/TH]
[TD="align: left"]=MOD(
R19,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U19[/TH]
[TD="align: left"]=MOD(
S19,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V19[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T19=TIME(23,0,0),S19=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T19=U19,"SAME",IF(
T19<u19,"earlier",if(T19>U19,"LATER"</u19,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S20[/TH]
[TD="align: left"]=VLOOKUP(
A20,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T20[/TH]
[TD="align: left"]=MOD(
R20,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U20[/TH]
[TD="align: left"]=MOD(
S20,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V20[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T20=TIME(23,0,0),S20=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T20=U20,"SAME",IF(
T20<u20,"earlier",if(T20>U20,"LATER"</u20,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S21[/TH]
[TD="align: left"]=VLOOKUP(
A21,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T21[/TH]
[TD="align: left"]=MOD(
R21,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U21[/TH]
[TD="align: left"]=MOD(
S21,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V21[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T21=TIME(23,0,0),S21=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T21=U21,"SAME",IF(
T21<u21,"earlier",if(T21>U21,"LATER"</u21,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S22[/TH]
[TD="align: left"]=VLOOKUP(
A22,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T22[/TH]
[TD="align: left"]=MOD(
R22,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U22[/TH]
[TD="align: left"]=MOD(
S22,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V22[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T22=TIME(23,0,0),S22=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T22=U22,"SAME",IF(
T22<u22,"earlier",if(T22>U22,"LATER"</u22,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R2[/TH]
[TD="align: left"]=IF(
Q2="SAME",J2,IF(AND(J2=$Y$10,Q2="EARLIER"),$Y$10,IF(Q2="EARLIER",J2-TIME(1,0,0),J2+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R3[/TH]
[TD="align: left"]=IF(
Q3="SAME",J3,IF(AND(J3=$Y$10,Q3="EARLIER"),$Y$10,IF(Q3="EARLIER",J3-TIME(1,0,0),J3+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R4[/TH]
[TD="align: left"]=IF(
Q4="SAME",J4,IF(AND(J4=$Y$10,Q4="EARLIER"),$Y$10,IF(Q4="EARLIER",J4-TIME(1,0,0),J4+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R5[/TH]
[TD="align: left"]=IF(
Q5="SAME",J5,IF(AND(J5=$Y$10,Q5="EARLIER"),$Y$10,IF(Q5="EARLIER",J5-TIME(1,0,0),J5+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R6[/TH]
[TD="align: left"]=IF(
Q6="SAME",J6,IF(AND(J6=$Y$10,Q6="EARLIER"),$Y$10,IF(Q6="EARLIER",J6-TIME(1,0,0),J6+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R7[/TH]
[TD="align: left"]=IF(
Q7="SAME",J7,IF(AND(J7=$Y$10,Q7="EARLIER"),$Y$10,IF(Q7="EARLIER",J7-TIME(1,0,0),J7+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R8[/TH]
[TD="align: left"]=IF(
Q8="SAME",J8,IF(AND(J8=$Y$10,Q8="EARLIER"),$Y$10,IF(Q8="EARLIER",J8-TIME(1,0,0),J8+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R9[/TH]
[TD="align: left"]=IF(
Q9="SAME",J9,IF(AND(J9=$Y$10,Q9="EARLIER"),$Y$10,IF(Q9="EARLIER",J9-TIME(1,0,0),J9+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R10[/TH]
[TD="align: left"]=IF(
Q10="SAME",J10,IF(AND(J10=$Y$10,Q10="EARLIER"),$Y$10,IF(Q10="EARLIER",J10-TIME(1,0,0),J10+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R11[/TH]
[TD="align: left"]=IF(
Q11="SAME",J11,IF(AND(J11=$Y$10,Q11="EARLIER"),$Y$10,IF(Q11="EARLIER",J11-TIME(1,0,0),J11+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R12[/TH]
[TD="align: left"]=IF(
Q12="SAME",J12,IF(AND(J12=$Y$10,Q12="EARLIER"),$Y$10,IF(Q12="EARLIER",J12-TIME(1,0,0),J12+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R14[/TH]
[TD="align: left"]=IF(
Q14="SAME",J14,IF(AND(J14=$Y$10,Q14="EARLIER"),$Y$10,IF(Q14="EARLIER",J14-TIME(1,0,0),J14+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R15[/TH]
[TD="align: left"]=IF(
Q15="SAME",J15,IF(AND(J15=$Y$10,Q15="EARLIER"),$Y$10,IF(Q15="EARLIER",J15-TIME(1,0,0),J15+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R16[/TH]
[TD="align: left"]=IF(
Q16="SAME",J16,IF(AND(J16=$Y$10,Q16="EARLIER"),$Y$10,IF(Q16="EARLIER",J16-TIME(1,0,0),J16+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R17[/TH]
[TD="align: left"]=IF(
Q17="SAME",J17,IF(AND(J17=$Y$10,Q17="EARLIER"),$Y$10,IF(Q17="EARLIER",J17-TIME(1,0,0),J17+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R18[/TH]
[TD="align: left"]=IF(
Q18="SAME",J18,IF(AND(J18=$Y$10,Q18="EARLIER"),$Y$10,IF(Q18="EARLIER",J18-TIME(1,0,0),J18+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R20[/TH]
[TD="align: left"]=IF(
Q20="SAME",J20,IF(AND(J20=$Y$10,Q20="EARLIER"),$Y$10,IF(Q20="EARLIER",J20-TIME(1,0,0),J20+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R21[/TH]
[TD="align: left"]=IF(
Q21="SAME",J21,IF(AND(J21=$Y$10,Q21="EARLIER"),$Y$10,IF(Q21="EARLIER",J21-TIME(1,0,0),J21+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R23[/TH]
[TD="align: left"]=IF(
Q23="SAME",J23,IF(AND(J23=$Y$10,Q23="EARLIER"),$Y$10,IF(Q23="EARLIER",J23-TIME(1,0,0),J23+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S23[/TH]
[TD="align: left"]=VLOOKUP(
A23,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T23[/TH]
[TD="align: left"]=MOD(
R23,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U23[/TH]
[TD="align: left"]=MOD(
S23,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V23[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T23=TIME(23,0,0),S23=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T23=U23,"SAME",IF(
T23<u23,"earlier",if(T23>U23,"LATER"</u23,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R24[/TH]
[TD="align: left"]=IF(
Q24="SAME",J24,IF(AND(J24=$Y$10,Q24="EARLIER"),$Y$10,IF(Q24="EARLIER",J24-TIME(1,0,0),J24+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S24[/TH]
[TD="align: left"]=VLOOKUP(
A24,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T24[/TH]
[TD="align: left"]=MOD(
R24,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U24[/TH]
[TD="align: left"]=MOD(
S24,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V24[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T24=TIME(23,0,0),S24=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T24=U24,"SAME",IF(
T24<u24,"earlier",if(T24>U24,"LATER"</u24,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R25[/TH]
[TD="align: left"]=IF(
Q25="SAME",J25,IF(AND(J25=$Y$10,Q25="EARLIER"),$Y$10,IF(Q25="EARLIER",J25-TIME(1,0,0),J25+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S25[/TH]
[TD="align: left"]=VLOOKUP(
A25,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T25[/TH]
[TD="align: left"]=MOD(
R25,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U25[/TH]
[TD="align: left"]=MOD(
S25,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V25[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T25=TIME(23,0,0),S25=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T25=U25,"SAME",IF(
T25<u25,"earlier",if(T25>U25,"LATER"</u25,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R26[/TH]
[TD="align: left"]=IF(
Q26="SAME",J26,IF(AND(J26=$Y$10,Q26="EARLIER"),$Y$10,IF(Q26="EARLIER",J26-TIME(1,0,0),J26+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S26[/TH]
[TD="align: left"]=VLOOKUP(
A26,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T26[/TH]
[TD="align: left"]=MOD(
R26,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U26[/TH]
[TD="align: left"]=MOD(
S26,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V26[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T26=TIME(23,0,0),S26=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T26=U26,"SAME",IF(
T26<u26,"earlier",if(T26>U26,"LATER"</u26,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R27[/TH]
[TD="align: left"]=IF(
Q27="SAME",J27,IF(AND(J27=$Y$10,Q27="EARLIER"),$Y$10,IF(Q27="EARLIER",J27-TIME(1,0,0),J27+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S27[/TH]
[TD="align: left"]=VLOOKUP(
A27,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T27[/TH]
[TD="align: left"]=MOD(
R27,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U27[/TH]
[TD="align: left"]=MOD(
S27,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V27[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T27=TIME(23,0,0),S27=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T27=U27,"SAME",IF(
T27<u27,"earlier",if(T27>U27,"LATER"</u27,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R28[/TH]
[TD="align: left"]=IF(
Q28="SAME",J28,IF(AND(J28=$Y$10,Q28="EARLIER"),$Y$10,IF(Q28="EARLIER",J28-TIME(1,0,0),J28+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S28[/TH]
[TD="align: left"]=VLOOKUP(
A28,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T28[/TH]
[TD="align: left"]=MOD(
R28,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U28[/TH]
[TD="align: left"]=MOD(
S28,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V28[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T28=TIME(23,0,0),S28=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T28=U28,"SAME",IF(
T28<u28,"earlier",if(T28>U28,"LATER"</u28,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R29[/TH]
[TD="align: left"]=IF(
Q29="SAME",J29,IF(AND(J29=$Y$10,Q29="EARLIER"),$Y$10,IF(Q29="EARLIER",J29-TIME(1,0,0),J29+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S29[/TH]
[TD="align: left"]=VLOOKUP(
A29,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T29[/TH]
[TD="align: left"]=MOD(
R29,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U29[/TH]
[TD="align: left"]=MOD(
S29,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V29[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T29=TIME(23,0,0),S29=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T29=U29,"SAME",IF(
T29<u29,"earlier",if(T29>U29,"LATER"</u29,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R30[/TH]
[TD="align: left"]=IF(
Q30="SAME",J30,IF(AND(J30=$Y$10,Q30="EARLIER"),$Y$10,IF(Q30="EARLIER",J30-TIME(1,0,0),J30+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S30[/TH]
[TD="align: left"]=VLOOKUP(
A30,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T30[/TH]
[TD="align: left"]=MOD(
R30,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U30[/TH]
[TD="align: left"]=MOD(
S30,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V30[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T30=TIME(23,0,0),S30=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T30=U30,"SAME",IF(
T30<u30,"earlier",if(T30>U30,"LATER"</u30,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R31[/TH]
[TD="align: left"]=IF(
Q31="SAME",J31,IF(AND(J31=$Y$10,Q31="EARLIER"),$Y$10,IF(Q31="EARLIER",J31-TIME(1,0,0),J31+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S31[/TH]
[TD="align: left"]=VLOOKUP(
A31,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T31[/TH]
[TD="align: left"]=MOD(
R31,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U31[/TH]
[TD="align: left"]=MOD(
S31,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V31[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T31=TIME(23,0,0),S31=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T31=U31,"SAME",IF(
T31<u31,"earlier",if(T31>U31,"LATER"</u31,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R32[/TH]
[TD="align: left"]=IF(
Q32="SAME",J32,IF(AND(J32=$Y$10,Q32="EARLIER"),$Y$10,IF(Q32="EARLIER",J32-TIME(1,0,0),J32+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S32[/TH]
[TD="align: left"]=VLOOKUP(
A32,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T32[/TH]
[TD="align: left"]=MOD(
R32,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U32[/TH]
[TD="align: left"]=MOD(
S32,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V32[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T32=TIME(23,0,0),S32=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T32=U32,"SAME",IF(
T32<u32,"earlier",if(T32>U32,"LATER"</u32,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R33[/TH]
[TD="align: left"]=IF(
Q33="SAME",J33,IF(AND(J33=$Y$10,Q33="EARLIER"),$Y$10,IF(Q33="EARLIER",J33-TIME(1,0,0),J33+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S33[/TH]
[TD="align: left"]=VLOOKUP(
A33,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T33[/TH]
[TD="align: left"]=MOD(
R33,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U33[/TH]
[TD="align: left"]=MOD(
S33,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V33[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T33=TIME(23,0,0),S33=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T33=U33,"SAME",IF(
T33<u33,"earlier",if(T33>U33,"LATER"</u33,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R34[/TH]
[TD="align: left"]=IF(
Q34="SAME",J34,IF(AND(J34=$Y$10,Q34="EARLIER"),$Y$10,IF(Q34="EARLIER",J34-TIME(1,0,0),J34+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S34[/TH]
[TD="align: left"]=VLOOKUP(
A34,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T34[/TH]
[TD="align: left"]=MOD(
R34,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U34[/TH]
[TD="align: left"]=MOD(
S34,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V34[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T34=TIME(23,0,0),S34=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T34=U34,"SAME",IF(
T34<u34,"earlier",if(T34>U34,"LATER"</u34,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R35[/TH]
[TD="align: left"]=IF(
Q35="SAME",J35,IF(AND(J35=$Y$10,Q35="EARLIER"),$Y$10,IF(Q35="EARLIER",J35-TIME(1,0,0),J35+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S35[/TH]
[TD="align: left"]=VLOOKUP(
A35,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T35[/TH]
[TD="align: left"]=MOD(
R35,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U35[/TH]
[TD="align: left"]=MOD(
S35,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V35[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T35=TIME(23,0,0),S35=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T35=U35,"SAME",IF(
T35<u35,"earlier",if(T35>U35,"LATER"</u35,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R36[/TH]
[TD="align: left"]=IF(
Q36="SAME",J36,IF(AND(J36=$Y$10,Q36="EARLIER"),$Y$10,IF(Q36="EARLIER",J36-TIME(1,0,0),J36+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S36[/TH]
[TD="align: left"]=VLOOKUP(
A36,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T36[/TH]
[TD="align: left"]=MOD(
R36,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U36[/TH]
[TD="align: left"]=MOD(
S36,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V36[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T36=TIME(23,0,0),S36=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T36=U36,"SAME",IF(
T36<u36,"earlier",if(T36>U36,"LATER"</u36,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R37[/TH]
[TD="align: left"]=IF(
Q37="SAME",J37,IF(AND(J37=$Y$10,Q37="EARLIER"),$Y$10,IF(Q37="EARLIER",J37-TIME(1,0,0),J37+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S37[/TH]
[TD="align: left"]=VLOOKUP(
A37,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T37[/TH]
[TD="align: left"]=MOD(
R37,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U37[/TH]
[TD="align: left"]=MOD(
S37,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V37[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T37=TIME(23,0,0),S37=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T37=U37,"SAME",IF(
T37<u37,"earlier",if(T37>U37,"LATER"</u37,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R38[/TH]
[TD="align: left"]=IF(
Q38="SAME",J38,IF(AND(J38=$Y$10,Q38="EARLIER"),$Y$10,IF(Q38="EARLIER",J38-TIME(1,0,0),J38+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S38[/TH]
[TD="align: left"]=VLOOKUP(
A38,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T38[/TH]
[TD="align: left"]=MOD(
R38,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U38[/TH]
[TD="align: left"]=MOD(
S38,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V38[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T38=TIME(23,0,0),S38=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T38=U38,"SAME",IF(
T38<u38,"earlier",if(T38>U38,"LATER"</u38,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R39[/TH]
[TD="align: left"]=IF(
Q39="SAME",J39,IF(AND(J39=$Y$10,Q39="EARLIER"),$Y$10,IF(Q39="EARLIER",J39-TIME(1,0,0),J39+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S39[/TH]
[TD="align: left"]=VLOOKUP(
A39,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T39[/TH]
[TD="align: left"]=MOD(
R39,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U39[/TH]
[TD="align: left"]=MOD(
S39,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V39[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T39=TIME(23,0,0),S39=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T39=U39,"SAME",IF(
T39<u39,"earlier",if(T39>U39,"LATER"</u39,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R40[/TH]
[TD="align: left"]=IF(
Q40="SAME",J40,IF(AND(J40=$Y$10,Q40="EARLIER"),$Y$10,IF(Q40="EARLIER",J40-TIME(1,0,0),J40+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S40[/TH]
[TD="align: left"]=VLOOKUP(
A40,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T40[/TH]
[TD="align: left"]=MOD(
R40,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U40[/TH]
[TD="align: left"]=MOD(
S40,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V40[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T40=TIME(23,0,0),S40=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T40=U40,"SAME",IF(
T40<u40,"earlier",if(T40>U40,"LATER"</u40,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R41[/TH]
[TD="align: left"]=IF(
Q41="SAME",J41,IF(AND(J41=$Y$10,Q41="EARLIER"),$Y$10,IF(Q41="EARLIER",J41-TIME(1,0,0),J41+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S41[/TH]
[TD="align: left"]=VLOOKUP(
A41,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T41[/TH]
[TD="align: left"]=MOD(
R41,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U41[/TH]
[TD="align: left"]=MOD(
S41,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V41[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T41=TIME(23,0,0),S41=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T41=U41,"SAME",IF(
T41<u41,"earlier",if(T41>U41,"LATER"</u41,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R42[/TH]
[TD="align: left"]=IF(
Q42="SAME",J42,IF(AND(J42=$Y$10,Q42="EARLIER"),$Y$10,IF(Q42="EARLIER",J42-TIME(1,0,0),J42+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S42[/TH]
[TD="align: left"]=VLOOKUP(
A42,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T42[/TH]
[TD="align: left"]=MOD(
R42,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U42[/TH]
[TD="align: left"]=MOD(
S42,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V42[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T42=TIME(23,0,0),S42=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T42=U42,"SAME",IF(
T42<u42,"earlier",if(T42>U42,"LATER"</u42,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R43[/TH]
[TD="align: left"]=IF(
Q43="SAME",J43,IF(AND(J43=$Y$10,Q43="EARLIER"),$Y$10,IF(Q43="EARLIER",J43-TIME(1,0,0),J43+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S43[/TH]
[TD="align: left"]=VLOOKUP(
A43,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T43[/TH]
[TD="align: left"]=MOD(
R43,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U43[/TH]
[TD="align: left"]=MOD(
S43,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V43[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T43=TIME(23,0,0),S43=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T43=U43,"SAME",IF(
T43<u43,"earlier",if(T43>U43,"LATER"</u43,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R44[/TH]
[TD="align: left"]=IF(
Q44="SAME",J44,IF(AND(J44=$Y$10,Q44="EARLIER"),$Y$10,IF(Q44="EARLIER",J44-TIME(1,0,0),J44+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S44[/TH]
[TD="align: left"]=VLOOKUP(
A44,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T44[/TH]
[TD="align: left"]=MOD(
R44,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U44[/TH]
[TD="align: left"]=MOD(
S44,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V44[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T44=TIME(23,0,0),S44=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T44=U44,"SAME",IF(
T44<u44,"earlier",if(T44>U44,"LATER"</u44,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R45[/TH]
[TD="align: left"]=IF(
Q45="SAME",J45,IF(AND(J45=$Y$10,Q45="EARLIER"),$Y$10,IF(Q45="EARLIER",J45-TIME(1,0,0),J45+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S45[/TH]
[TD="align: left"]=VLOOKUP(
A45,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T45[/TH]
[TD="align: left"]=MOD(
R45,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U45[/TH]
[TD="align: left"]=MOD(
S45,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V45[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T45=TIME(23,0,0),S45=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T45=U45,"SAME",IF(
T45<u45,"earlier",if(T45>U45,"LATER"</u45,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R46[/TH]
[TD="align: left"]=IF(
Q46="SAME",J46,IF(AND(J46=$Y$10,Q46="EARLIER"),$Y$10,IF(Q46="EARLIER",J46-TIME(1,0,0),J46+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S46[/TH]
[TD="align: left"]=VLOOKUP(
A46,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T46[/TH]
[TD="align: left"]=MOD(
R46,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U46[/TH]
[TD="align: left"]=MOD(
S46,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V46[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T46=TIME(23,0,0),S46=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T46=U46,"SAME",IF(
T46<u46,"earlier",if(T46>U46,"LATER"</u46,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R47[/TH]
[TD="align: left"]=IF(
Q47="SAME",J47,IF(AND(J47=$Y$10,Q47="EARLIER"),$Y$10,IF(Q47="EARLIER",J47-TIME(1,0,0),J47+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S47[/TH]
[TD="align: left"]=VLOOKUP(
A47,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T47[/TH]
[TD="align: left"]=MOD(
R47,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U47[/TH]
[TD="align: left"]=MOD(
S47,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V47[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T47=TIME(23,0,0),S47=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T47=U47,"SAME",IF(
T47<u47,"earlier",if(T47>U47,"LATER"</u47,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R48[/TH]
[TD="align: left"]=IF(
Q48="SAME",J48,IF(AND(J48=$Y$10,Q48="EARLIER"),$Y$10,IF(Q48="EARLIER",J48-TIME(1,0,0),J48+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S48[/TH]
[TD="align: left"]=VLOOKUP(
A48,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T48[/TH]
[TD="align: left"]=MOD(
R48,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U48[/TH]
[TD="align: left"]=MOD(
S48,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V48[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T48=TIME(23,0,0),S48=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T48=U48,"SAME",IF(
T48<u48,"earlier",if(T48>U48,"LATER"</u48,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R49[/TH]
[TD="align: left"]=IF(
Q49="SAME",J49,IF(AND(J49=$Y$10,Q49="EARLIER"),$Y$10,IF(Q49="EARLIER",J49-TIME(1,0,0),J49+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S49[/TH]
[TD="align: left"]=VLOOKUP(
A49,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T49[/TH]
[TD="align: left"]=MOD(
R49,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U49[/TH]
[TD="align: left"]=MOD(
S49,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V49[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T49=TIME(23,0,0),S49=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T49=U49,"SAME",IF(
T49<u49,"earlier",if(T49>U49,"LATER"</u49,"earlier",if())))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]R50[/TH]
[TD="align: left"]=IF(
Q50="SAME",J50,IF(AND(J50=$Y$10,Q50="EARLIER"),$Y$10,IF(Q50="EARLIER",J50-TIME(1,0,0),J50+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S50[/TH]
[TD="align: left"]=VLOOKUP(
A50,'S:\Scratch\Chris Cole\Labor Model 4.1\NBO\Gold Standard - Master Paramters & Hours\[2019 Master Guide with Hours - AT.xls]Master'!$B$15:$H$405,7,FALSE)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T50[/TH]
[TD="align: left"]=MOD(
R50,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]U50[/TH]
[TD="align: left"]=MOD(
S50,1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]V50[/TH]
[TD="align: left"]=IF(<font color="Blue">AND(
T50=TIME(23,0,0),S50=TIME(0,0,0)),"EARLIER",IF(<font color="Red">T50=U50,"SAME",IF(
T50<u50,"earlier",if(T50>U50,"LATER"</u50,"earlier",if())))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
</u2,"earlier",if(t2>