https://bz.apache.org/ooo/show_bug.cgi?id=127850
Issue ID: 127850
Issue Type: DEFECT
Summary: Time Calculation using formulas
Product: Calc
Version: 4.1.5
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: ui
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 86486
--> https://bz.apache.org/ooo/attachment.cgi?id=86486&action=edit
OpenOffice Calc file showing bug in result of series of formulas.
Example: Time from 14:00 to 22:00 total 8 hours - formula works fine, no
issues.
From 19:00 to 07:00 total 12 hours, shows correct number, but following
formulas will bug. For example if I want it to multiply total time (12 hours)
by $8 it should show $96, but it will show wrong number. But it shows correct
number if it's a day shift.
Also it doesn't like to use commas in formulas. So have to round up mileage...
I attach a part of my spreadsheet which shows a bug if you create a formula to
calculate total time and the result is used in next formula of a following
cells. As soon you use different date times, it bugs.
Also if you look at RATE it is in General Numbers instead of Currency. If I
use Currency in formula, it will show #VALUE in TOTAL INC.
--
You are receiving this mail because:
You are the assignee for the issue.
