Issue 73793 - There's no field format for durations
Summary: There's no field format for durations
Alias: None
Product: General
Classification: Code
Component: code (show other issues)
Version: OOo 2.1
Hardware: All All
: P3 Minor (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-01-23 12:11 UTC by windl
Modified: 2014-02-13 13:36 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description windl 2007-01-23 12:11:12 UTC
In Writer, there's a field that displays the total amount of time spent for the
document. However the suggested formats to display it are all "time" formats,
not "duration" formats. Actually there's no format for durations.
The problem becomes obvious when you've spent more than 12:59:59 on a document.
Then the duration is displayed, depending on the selected format, in odd ways.
If you had selected HH:MM:SS, everything above 24 hours is silently ignored
(that is you see the remainder). Therefore I suggest to introduce formats for
An obvious format might be (optional parts in []):
[[[[3 years, ]12 weeks, ]7 hours, ]9 minutes, and ]17 seconds
But in a first step, counting and displaying days would be OK: "2640 days and
07:09:17"... You get the idea.
Comment 1 thorsten.martens 2007-01-25 10:50:35 UTC
TM->requirements: please have a look, thanks !
Comment 2 windl 2010-01-14 12:28:48 UTC
After three years of being unconfirmed, I'd like to point out that it's still an
issue, and yet another format would be D+HH:MM:SS (D=Days, H,M,S= the obvious
(Hours, Minutes, Seconds).
Also some basic maths:
Duration + or - Duration -> Duration
Time - Time -> Duration
Time + or - Duration -> Time

So basically date and time mathematics is incomplete without durations.
Comment 3 Edwin Sharp 2014-02-13 13:36:13 UTC
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1565724
Win 7

IMHO if total editing time>12:59:59 then fuzzy logic by default