[Issue 127850] Time Calculation using formulas

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127850

Peter <le...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |leginee@gmail.com
         Resolution|---                         |NOT_AN_OOO_ISSUE
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #1 from Peter <le...@gmail.com> ---
Aß dritten in Mail it is all a missunderstanding.if it helps Herr is the
explanation again. If Three See questions Please send a Mail to Users Le dev
Mailing List.

This accounts for cases where the end time (H4) has a smaller clock value (e.g.
07:00) than the start time (e.g. 19:00) but is in the next day. Times are
stored in units of days. The time 07:00 has the value 7/24 and the time 19:00
has the value 19/24. You were subtracting
7/24 - 19/24 = -12/24 = -0.5
If a cell is formatted as time, -0.5 is displayed as12:00, but the value is
still -0.5. 
I appended
+ (G4 > H4) 
which returns FALSE (equal to zero) when H4 is larger than or equal to G4. When
G4 is larger than H4, it returns TRUE (equal to one) that gives
H4-G4 + (G4 >H4) = 7/24 - 19/24 + (19/24 > 7/24) = -0.5 + (TRUE) = -0.5 + 1 =
0.5
The 0.5, when formatted as time, is 12:00 and it is the desired answer. This is
not a bug. All spreadsheets treat times as fractions of a day.

Closing AS mit an issue.

-- 
You are receiving this mail because:
You are the assignee for the issue.