[OASIS Issue Tracker] Created: (OFFICE-1829) elapsed time formatstyle required

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

elapsed time format style required
----------------------------------

                 Key: OFFICE-1829
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1829
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: Improvement
          Components: Table
    Affects Versions: ODF 1.2
            Reporter: Andreas Guelzow 


Programs such as Gnumeric provide an "elapsed time"  time style: [h]:mm:ss which interprets the hours not as a time but as a time duration, so the presentation may look like: 34:12:00
(34 hours, 12 minutes and 0 seconds). SImilarly [mm]:ss would yield 194:12 (194 minutes and 12 hours). THis appears to be a heavily used format.

Currently this can't be achieved in ODF styles:
time-style does not appear to provide a way of specifying that the hours (or minutes) should consider the whole value.
number style cannot be used since one can only show a single number (and one can't calulate the seconds from within that style.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira