Hi all, 1st post
I have been wrestling this for hours and am seeking help before my mind melts please.
Here is the Data
ExcelDat.png
Here are the formulae so far
ExcelFor.png
The 2 gray are additional hours worked.
All 3 Adj columns and the Worked work!
The Total does not and will not whatever I do
It needs to be
if contract = 37(fulltime) it is simply the 2 adj added together
if contract + hours worked <37, it is simply the adjusted hours
however if contract + hours worked >37, it is the extra hours worked above contract + the extra adj hours NOT INCLUDING THE HOURS ADJUSTED BY
Does that make sense!? It's got me completely befuddled.
Bookmarks