Formula for calculating total hours from shift timings in Apple Numbers

It's easier than you are probably thinking. In Numbers a simple subtraction will do, like this:

Click or tap in D3, enter =, click/tap C2, enter -, click/tap B2 and have Numbers accept the formula.

To get the total for the week make the last row of the table a Footer Row and in D5 enter =SUM(D).

If you must have blank rows at the bottom before the Header Row then you can make the subtraction formula a little fancier. See the 'Sign In' table in the built-in 'Employee Worksheet' template.

For something like this I would just remove any blank rows. Then when I need a new one I go to the last body row and hit enter. A new row appears with the formula carried down automatically.

SG

Yes, the way to fix that is to, as in my example, make the last row a Footer Row and put the SUM formula that Footer Row.

Also, you need to delete the blank rows above that last row, as in my example.



SG

You can't ask Numbers to calculate D4 when D4's formula is =SUM(D4)

A SUM calculation can't reference itself.

Instead, what SGIII is trying to tell you is that you should add a Footer row to the table:

Then, in the Footer Row, set the formula to =SUM(D)

This will sum all the values in column D, omitting the Header and Footer rows.

If you put the formula in the main table (i.e. not in a header or footer cell) then your calculation becomes more complicated since you need to be more specific about which cells to add, whereas the footer row does this automatically.

No blank rows anywhere! Formula goes in the Footer Row.

SG