Issue 73793

Summary: There's no field format for durations
Product: General Reporter: windl <ulrich.windl>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Minor    
Priority: P3 CC: elish, issues
Version: OOo 2.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

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
durations.
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
Rev.1565724
Win 7

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