In the example file it looks like hardly anyone worked. I'm sure this is not the case and the OP has just exaggerated how the data might appear, though it is a bit misleading.

Pete

EDIT:

@Jerry,

you will need to take account of this FMLA leave, which is not shown in the example (yes, I can see where it should go, but the OP might not).

Pete