Bug 142320 - Gnumeric can distinguish durations from times of day (TOD); the lack of this ability in Libroffice Calc constitutes a defect in requirements analysis.
Summary: Gnumeric can distinguish durations from times of day (TOD); the lack of this ...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-05-16 20:59 UTC by Jack WAUGH
Modified: 2021-05-18 13:14 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jack WAUGH 2021-05-16 20:59:42 UTC 
Gnumeric can be told to store a time duration and not treat it as a time of day (TOD). The lack of this ability in Libroffice Calc constitutes a defect in requirements analysis.
Comment 1 [REDACTED] 2021-05-17 10:02:18 UTC 
(In reply to Jack WAUGH from comment #0)
> Gnumeric can be told to store a time duration and not treat it as a time of
> day (TOD). The lack of this ability in Libroffice Calc constitutes a defect
> in requirements analysis.

Formatting "time durations" in Calc is done by format code "[HH]:MM". Isn't that what you are looking for?

Ref.: https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html?DbPAR=SHARED#bm_id3153514 - Section Time Formats
Comment 2 Jack WAUGH 2021-05-17 23:16:23 UTC 
OK, the format code you give works, and still works if :SS is appended to the end. So no analysis, design, or code change is needed. The answer at https://ask.libreoffice.org/en/question/139750/time-as-duration/ mislead me and I think it should be changed to point out what you have here pointed out. The relevant doc and the solution.