I need someone to create an excel formula/set of formulas/worksheet to calculated staff hours from an excel spreadsheet (attached)
The sheet provides the clock in and out time for each staff member on each day of the week and I need a formula that will calculate the total hours worked per month for each staff member from the above data.
The sheet attempts to calculate the total hours on page 1 'summary' but this number isn't correct.
