I have simplified this as much as I can:
I would like to keep track of when overtime is being worked and by who.
So in the sample, I have four employees over a period of five days working hours both above and below their contracted daily hours.
In the outlined cells I want to return how much time each employee worked beyond their contracted daily hours and how many hours employees worked beyond their contracted hours on each day. I am not interested in days where less hours were worked.
I hope this makes a bit more sense and many thanks to those who have aided me so far.
Column C should have a total of...
Erm, how does a column have a total? A cell can have a total! Did you meanC4
?