I’m trying to get the following table with calculations to work
| date | activity | duration |
| ---------- | -------------------- | -------- |
| 25-08-2021 | Activity 1 | 15 |
| 12-10-2021 | Activity 2 | 65 |
| 22-10-2021 | Activity 3 | 50 |
| 01-11-2021 | Activity 4 | 135 |
| | Total in minutes | |
| | Total in hours | |
<!-- TBLFM: @>$3=sum(@I..@-1) -->
<!-- TBLFM: @>$3=(@-1/60) -->
But I run into the following problem.
If I place the cursor in the third column of the second last row and press the ‘fx’ button, it just returns a 0 in the third column of the last row.
I can’t get it to calculate the two fields concurrently.
Any ideas how to get this working would be greatly appreciated.
Thanks in advance.