Bug 153625 - Add function for calculating (add, sum) of running times (minutes, seconds)
Summary: Add function for calculating (add, sum) of running times (minutes, seconds)
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-02-14 22:24 UTC by James E. LaBarre
Modified: 2023-02-14 22:42 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.