Calc: SUM function (very basic question)

jeshkhol · October 20, 2023, 9:52am

7.6.2.1
macOS 12.7

I have a simple spreadsheet:

column G notes the time difference (= duration) between the values in columns C and D
column I is the total of column G

Column H should calculate the subtotals of various sets within column G, e.g., from G2 to G17, from G18 to G 67, etc. So for the first of these subtotals, I have entered =SUM(G2:G17), and the result is what I expect.

However, all the other subtotals in column G seem not to work as expected, because the sum in H651 should be identical to the figure in column I. I fail to see what I’m doing wrong. Could anyone help?

karolus · October 20, 2023, 10:02am

Works fine:

781:58:00	781:58:00
=SUM(H1:H650)	=SUM(G:G)

jeshkhol · October 20, 2023, 10:40am

I only get 13:58:00 …
sum2

karolus · October 20, 2023, 10:43am

Wrong Format… change NumberFormatCode to: [HH]:MM:SS

PKG · October 20, 2023, 10:48am

jeshkhol · October 20, 2023, 10:59am

Thank you! (I need to learn more about how to format time cells.)

jeshkhol · October 20, 2023, 11:03am

I hadn’t noticed this discrepancy. When I try to change the value to 80:03:00 (which is the correct one) it reverts to 08:03:00. How did you change it?

EDIT: I managed to change it by applying a new format to the cell.