[Dropped] How to total multiple time in Calc

[lavarne04]

Hello,

I have a problem adding multiple time in calc example

00:29:41
00:04:24
00:11:14
00:45:29
00:12:12
00:23:10
00:05:55

when I use =sum the result is 00:00

what formula I can use on this?

Thanks

[robleyd]

Welcome to the forum.

Without seeing the actual spreadsheet file I'll take a guess; your times are actually entered as text, and SUM doesn't add test values. To show cell content types, quoted from HELP:

Value Highlighting
Displays cell contents in different colors, depending on type.
To remove the highlighting, unmark the menu entry.

To access this command...
Choose View - Value Highlighting

Text cells are formatted in black, formulae in green, and number cells in blue, no matter how their display is formatted.

If this function is active, colours that you define in the document will not be displayed. When you deactivate the function, the user-defined colours are displayed again.

[Tutorial] Text to Columns has hints on converting text values to numbers/dates/time.

If you are new to spreadsheets you may find [Tutorial] Ten concepts that very Calc user should know to be a useful resource.

[Alex1]

When you add times make sure the result is formatted as a duration: [HH]:MM:SS instead of clock time: HH:MM:SS.
The latter will show the sum modulo 24 hours.