[Solved] Sum times in table

Discuss the word processor
Locked
User avatar
donnje
Posts: 74
Joined: Sun Apr 20, 2025 4:06 pm

[Solved] Sum times in table

Post 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 
Attachments
Hours.odt
(10.74 KiB) Downloaded 58 times
Last edited by MrProgrammer on Fri Jan 30, 2026 10:44 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved]
LibreOffice 24.8.6.2
User avatar
robleyd
Moderator
Posts: 5509
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Time calculator formula

Post 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.
Attachments
Hours01.odt
(11.76 KiB) Downloaded 44 times
Slackware 15 (current) 64 bit
Apache OpenOffice 4.1.16
LibreOffice 26.2.3.2; SlackBuild for 26.2.3 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
User avatar
Lupp
Volunteer
Posts: 3756
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Time calculator formula

Post 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
On Windows 10: LibreOffice 25.8.4 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Locked