Maybe I'm doing this wrong. Column A reads like this
Week 1 39.00 hours
2 39.00 hours
3 39.00 hours
4 39.00 hours
5 39.00 hours
6 39.00 hours
Total 280.14 hours
Divided by 22.00 per hour
Total 12.73 hours
I'm thoroughly confused. If you've got 6 lots of 39 hours, that adds up to
234 hours, not 280.14. What does the formula in that cell say, and what
format is in that cell, and in the cells with 39.00 hours (and what does the
formula bar show where you've got 39.00 in the cell)?
But if you do end up with 280.14 and divide it by 22 to give 12.73, then
that's decimal hours, so would be 12 hours & 44 minutes, not 13 hours 13
minutes.