its the way the hours are worked out and its to do with a 44 hour threshold
if you unhide and work through the formulas - you will see how they are calculating, and you will need to see if thats a logical way to calculate for you situation. Is that how you want it to work now.
if you put an 1 in for each day , sunday populates
but if the hours are over 44 then negative numbers are entered and -8 then displays 0 for a day
not sure i understand the logic
but thats what the formula appears to be doing
Bookmarks