Formula for if time is same, earlier or later?

tblackwell

New Member
Joined
Oct 24, 2018
Messages
28
Office Version
  1. 365
Platform
  1. Windows
QUESTION: Can you help me create a formula that looks at time in two different columns and determines if the time is the same, earlier or later? For perspective, this is to determine difference in closing time this winter compared to this summer.

Sample data below.

CURRENT FORMULA: =IF(R2=S2,"SAME",IF(R2>S2,"EARLIER",IF(R2<s2,"later")))<s2,"later")))<s2,"later")))


Issues: This formula thinks that 12:00:00 AM is earlier than 11:00:00 PM, that 10:00:00 PM is later than 11:00:00 PM, 1:00:00 AM is earlier than 12:00:00 AM, and so forth.

DESIRED OUTCOME: If column R is closing earlier than column S then "earlier", if column R is closing later than column S then "later", if column R is same time as column S then "same"

Windows 10 Pro, Office 365

Please help!


ARST
StoreWinter Hours TY Close TimeCurrent Summer Hours Close TimeTime Difference Winter versus Summer
SAME
EARLIER
EARLIER
EARLIER
EARLIER
EARLIER
EARLIER
EARLIER
EARLIER
EARLIER
LATER
LATER
EARLIER
EARLIER
EARLIER
EARLIER
EARLIER
LATER
EARLIER
LATER
EARLIER
SAME
LATER
EARLIER
SAME
LATER
EARLIER
LATER
LATER
EARLIER
EARLIER
LATER
EARLIER
EARLIER
EARLIER
EARLIER
LATER
EARLIER
EARLIER
EARLIER
EARLIER
LATER
LATER
LATER
EARLIER
EARLIER
EARLIER
EARLIER
EARLIER

<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: 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: 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: center"]5[/TD]
[TD="align: right"]6004[/TD]
[TD="align: right"]12:00:00 AM[/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: 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: 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: center"]9[/TD]
[TD="align: right"]6008[/TD]
[TD="align: right"]12:00:00 AM[/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: 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: 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: center"]13[/TD]
[TD="align: right"]6012[/TD]
[TD="align: right"]10: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: 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: 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: 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: 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: center"]19[/TD]
[TD="align: right"]6019[/TD]
[TD="align: right"]10: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: 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: center"]22[/TD]
[TD="align: right"]6023[/TD]
[TD="align: right"]11: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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: center"]50[/TD]
[TD="align: right"]6064[/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]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]R2[/TH]
[TD="align: left"]=IF(Q2="SAME",J2,IF(AND(J2=$W$10,Q2="EARLIER"),$W$10,IF(Q2="EARLIER",J2-TIME(1,0,0),J2+TIME(1,0,0))))[/TD]
[/TR]
[TR]
[TH]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]T2
[/TH]
[TD="align: left"]=IF(R2=S2,"SAME",IF(R2>S2,"EARLIER",IF(R2<s2,"later"< font="">)</s2,"later"<>))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


</s2,"later")))<s2,"later")))<s2,"later")))
 
Last edited by a moderator:

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
This formula thinks that 12:00:00 AM is earlier than 11:00:00 PM

Technically, this is true. 12:00 AM is midnight, the beginning of the day ("0:00" in Military time).
If you want to say that it should be the end of the day, you will need to account for that explicitly in your IF formula.


that 10:00:00 PM is later than 11:00:00 PM, 1:00:00 AM is earlier than 12:00:00 AM, and so forth.
The only way Excel would think that is if the "date" parts of the entires are different.
It is important to note that even if you do not show the date parts, ithey are still there. If you temporarily change the format of your cells to see the date, then it will be obvious what it is comparing, and should explain the results you are seeing.

It is important to understand how Excel stores dates and times. It stores them as numbers, specifically the number of days since 1/0/1900. And time is just a fractional component of one day. Then the number is formatted with a Date/Time format for display purposes. If you change the format of any valid Date/Time entry to "General", you will see it exactly as Excel does.

If you want to compare strictly the time component of each cell (and ignore any day component), you can do that by only comparing the decimal portions of each entry. So, if you have an entry in cell A1, and want only the fractional time compenent, you can remove the date piece by getting rid of the whole number part, just leaving the fraction like this:
=R2-TRUNC(R2)

​So, if you wanted to compare the time components only of R2 ands S2, it would start out something like this:
Code:
=IF((R2-TRUNC(R2))=(S2-TRUNC(S2)),...
 
Last edited:
Upvote 0
If there are dates in the cells with the times, you could eliminate the nested IF like this:

=TEXT(MOD(S2,1)-MOD(R2,1),"""LATER"";""EARLIER"";""SAME""")
 
Upvote 0
Doh! I got caught in a VBA way of thinking!

You don't actual need to use:
Code:
R2-TRUNC(R2)
and can use the simpler:
Code:
MOD(R2,1)
instead (as MOD returns the remainder of the first number when divided by the second number).

I forgot that while VBA does not have a MOD remainder function, Excel does!
(Thanks for the reminder, Scott!)

So everything I said in my initial reply is still true, Scott just pointed out a slightly simpler way of dealing with it.
 
Last edited:
Upvote 0
Good idea, unfortunately no dates are in the cells.
Why do you say that? Did you try to expand them out, like I said?
Choose one of the Formats that has both Date and Time, and see what it shows the contents of your cells are.

Even if they were to have no Date component (or I should more accurately say, a zero date component, as they ALL have date components), Scott's function would not hurt anything and would still work.

If you have something that is not working for you, please pick a particular example that is not working, post the data values you are comparing after you change the cell formats to show both Date and Time, and show us the formula you are using (after making Scott's edits), what it is returning, and what you expect it to return.
 
Upvote 0
@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...


ARSTUV
StoreWinter Hours TY Close TimeCurrent Summer Hours Close TimeMOD Winter Hours TY Close TimeMOD Current Summer Hours Close TimeTIME 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>
 
Upvote 0
Any ideas on "tricking" excel to think that 11pm is "earlier" than 12am?
Is that the only remainining issue?
If not, and there others, please change the format of all the time columns to "mm/dd/yyyy hh:mm" and post the data again, and let us know which row isn't working.
I am headed out for a while, but will be back later.
 
Last edited:
Upvote 0
@Joe4 @Scott_Huish

Thanks for your help today. Unfortunately due to the time sensitivity of this project I had to move on to other things.

If you have any other ideas about how I might set this up for success next time, I am all ears. This is a twice a year project and this is the thing that I continually get stuck on. It's user error I'm sure, just wish there was an easier way to solve this.

Thanks.
 
Last edited:
Upvote 0
Regarding the time of 12:00 AM, that would be a date/time number with no time piece, so the fractional part would be zero.
So, to get it to be greater than all the the other ones, you could add one day (24 hours) to it.

So you could replace this:
Code:
[COLOR=#333333]=MOD([/COLOR][COLOR=Blue]R2,1[/COLOR][COLOR=#333333])
[/COLOR]
with this:
Code:
=IF(MOD(R2,1)=0,1,MOD(R2,1))
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,242
Members
452,623
Latest member
russelllowellpercy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top