https://bugs.freedesktop.org/show_bug.cgi?id=83414
Priority: medium
Bug ID: 83414
Assignee: [email protected]
Summary: Other: Error calculating time
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 105634
--> https://bugs.freedesktop.org/attachment.cgi?id=105634&action=edit
Selfexplanatory. Read text included.
Problem description:
Well, basicaly I entered a serious of values representing times (the duration
of some tutorials actually) but, when I tried to sum them & get the answer in
Days:hours:minutis:seconds format I get 1 day less than the correct answer. I
did the same calculation in Excel & I got the right amount.
Steps to reproduce:
1. Pasted several times in a column
2. Used Autosum to get the value in normal H:m:s format.
3. Changed format to "[h]:mm:ss" to get the total amount of hours.
4. Changed format to "d:hh:mm:ss" to get days as an added value.
See attached image to compare.
Thanks.
Bazan, Marcelo.
Operating System: Windows 7
Version: 4.2.5.2 release
--
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
