FG
💻 Software

LibreOffice Calc: How to get total for HH:MM:SS cells

Fresh7 days ago
Mar 15, 202647733 views
Confidence Score0%
0%

Problem

I'd like to take a group of cells in the HH:MM:SS format, and add them up. I don't want to have the value wrap on the 24 hour clock. I just want an absolute total of the values. (The sum function seems to wrap by default). So if I have: I want to end up with: A contrived example, but it gets across…

Error Output

20:00:00
20:00:00
00:10:00
00:00:10
00:00:10

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: LibreOffice Calc: How to get total for HH:MM:SS cells

Low Risk

It's a matter of formatting the cells. You will have to apply the format code . It's already predefined: (Screenshot from LibreOffice 3.4.3)

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment