For one month, you should only need three columns.
Col A: start time
Col B: end time
Col C: calculation (end minus start equals hours worked)
At the end of Col C, a sum formula to sum the hours in Col C. Work increments in full hours should not be a problem, but if there are partial hours, the formula becomes more complex, using conditional statements in the formula.
Do the same for each month of the year.
|