Page 1 of 1

[Solved] Sum times in table

Posted: Fri Jan 23, 2026 5:10 pm
by donnje
Hello,
Is there a sum formula that recognizes the time format to insert in the last line?
Thanks


P:S:Calc would be more suitable but I need it on write
 Edit: Changed subject, was Time calculator formula 
Make your post understandable by others 
-- MrProgrammer, forum moderator 

Re: Time calculator formula

Posted: Fri Jan 23, 2026 11:21 pm
by robleyd
Like this? I used Table | Number Format to set the format in A7, and Table | Edit Formula using the Functions dropdown to select the function.

Re: Time calculator formula

Posted: Fri Jan 23, 2026 11:28 pm
by Lupp
The rudimentary capabilities of calculating in a Writer TextTable are next to unuseable.
They probably are only implemented for a kind of compatibility with senile MS Word.
If you actually have to calculate use Calc. In specific cases it is appropriate to embed a Calc model into a Writer document by OLE.
See also:
aoo_113333_WriterTimeCalc_ReHours.odt
(15.59 KiB) Downloaded 49 times