=SUM(D30:R30,D16:S16)
and format the cell [h]:mm:ss
Temporarily format all the cells included in your sum formula [h]:mm:ss and visually chack that they contain the values you expect. Especially cells D16 and H16 among others.
Nonsense! It gives the number of hours in each cell.No, that gives military time.
Nonsense! It gives the number of hours in each cell.
Also, if there is non-billable time it will subtract that's what the +12 is it's row 12
12 what? sseconds? minutes? hours? days?
Cell D16!!What's the 12 about in this formula in cell D16:
=(D11+D15)+12
??
I'm talking about row 16, NOT ROW 12!It subtracts any non-billable times
I'm talking about row 16, NOT ROW 12!
The 12 is a hard-coded 12 in the formula, and it adds (not subtracts) 12. The formula in cell D16 (yes, the one in row 16, not row 12).
What's the value 12 doing there?
I now have no hair left to tear out.
It does not! it adds the value 12 and doesn't even look at row 12! In this context it adds 12 days (=288 hours). Barmy.plus it subtracts row 12