https://bugs.documentfoundation.org/show_bug.cgi?id=97334

--- Comment #7 from Dennis Roczek <[email protected]> ---
Another function which is missing: DURATION

Apple's DURATION is giving actually a duration (e.g. 1h).

>From Apple's help file:
DURATION
The DURATION function combines separate values for weeks, days, hours, minutes, 
seconds, and milliseconds and returns a duration value.
DURATION(weeks, days, hours, minutes, seconds, milliseconds)

weeks: A value representing the number of weeks. weeks is a number value.
days: An optional value representing the number of days. days is a number
value.
hours: An optional value representing the number of hours. hours is a number
value.
minutes: An optional value representing the number of minutes. minutes is a 
number value.
seconds: An optional value representing the number of seconds. seconds is a 
number value.
milliseconds: An optional value representing the number of milliseconds. 
milliseconds is a number value.
Usage Notes
 An argument that is 0 can be omitted, but the comma must be included if later 
 Â
values are included. For example, =DURATION(, ,12, 3) would return a duration
value 
of 12h 3m (12 hours and 3 minutes).
Negative values are permitted. For example, =DURATION(0, 2, -24) would return a
  Â
duration of 1 day (2 days minus 24 hours).

Our DURATION (and MDURATION and DURATION_ADD) are calculation a rates
(financial stuff).

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to