https://bugs.freedesktop.org/show_bug.cgi?id=70262
Priority: medium
Bug ID: 70262
Assignee: [email protected]
Summary: Time formatting for adding times > 24 h
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.2.3 rc
Component: Spreadsheet
Product: LibreOffice
This is a more specific issue than 65267. When I set up a table adding HH:MM:SS
and the total goes beyond 24 hours, the totals are now unpredictable. Previous
versions (and I think Excel) will allow hour totals greater than 24. This
appears to be a change in version 4.
I realize there is the work-around, sort-of to use the number and integer part
and fractional part, but it worked the way I described in version 3.
Why would one want more than 24 hours in time? Well, ask the U.S. Public
Broadcasting Service: They had a 30-hour clock to accommodate timezones across
the USA. In my case, I am recording total hours of lectures that I am
digitizing for archives. Each lecture may be an hour and a half and one box of
tapes might contain 33 hours of lectures (for example).
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
