https://bugs.freedesktop.org/show_bug.cgi?id=61132
Priority: medium
Bug ID: 61132
Assignee: [email protected]
Summary: FORMATTING: Cannot Sum the result of Time function
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 75126
--> https://bugs.freedesktop.org/attachment.cgi?id=75126&action=edit
A sample of what i'm trying to explain
Problem description:
I've create a spreadsheet containing some duration. For this, i'm using the
TIME() function as this : =TIME(0;30;0) to display 30 min.
Each cell is formatted as a Time 'HH:MM'
At the end of this column i want to Sum all thoses time. I cannot format this
Sum as a Time, but as a simple number. When i'm trying to Sum some Time, the
result is unreal !
Hey, as i'm writing this bug report, i've seen that the TIME() function doesn't
like more than 24 hours ! This might explain this result...
Steps to reproduce:
1. Add some time in a column using the function TIME(H;M;S)
2. Calculate a Sum of those time
3. Change the format of this Sum as Time in 'HH:MM'
4. Change again this format as simple Number.
Operating System: Ubuntu
Version: 4.0.0.3 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
