Bug 153625

Summary: Add function for calculating (add, sum) of running times (minutes, seconds)
Product: LibreOffice Reporter: James E. LaBarre <j.e.labarre>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: UNCONFIRMED ---    
Severity: enhancement    
Priority: medium    
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description James E. LaBarre 2023-02-14 22:24:42 UTC 
I would like to see a function to handle adding/subtracting/running total/sum of elapsed times (usually minutes & seconds).  The solutions usually presented require either breaking up a MM:SS "number" into multiple columns, or some hack that uses time-of-day (which isn't very reliable and prone to significant errors).
Comment 1 James E. LaBarre 2023-02-14 22:26:05 UTC 
Just to add to this:  I have been looking for a simple, straightforward way to do this in a chart/spreadsheet for over 25 years now, and I'm surprised it's never been implemented.
Comment 2 Mike Kaganski 2023-02-14 22:42:45 UTC 
(In reply to James E. LaBarre from comment #0)
> The solutions usually presented

Please describe which solutions you point to, which specific data you work with, what result you see, and what is your expectation.

I would expect, that for a set of durations, a simple SUM(A1:B10), formatted as a duration (i.e., "[MM]:SS" using square brackets to denote durations, as opposed to wall clock time) would do the job.