Apache OpenOffice (AOO) Bugzilla – Issue 73793
There's no field format for durations
Last modified: 2014-02-13 13:36:13 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.
TM->requirements: please have a look, thanks !
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.
Confirmed with AOO410m1(Build:9750) - Rev. 1565724 Rev.1565724 Win 7 IMHO if total editing time>12:59:59 then fuzzy logic by default