In LO 7.2 Calc,
suppose I have in A1 an end date time and A2 a start date time
A1 =2022-01-02 11:00
A2 =2021-12-20 12:00
In B1, I wish to have the date time differences in decimal of the (end - start) dates.
datediff(A2;A1;“d”) returns the date difference as an INTEGER in days but this is not what I want.
In the English Help, I do not see an option for hours, minutes or seconds:
However, surprisingly I do see an option in the FRENCH version
My LO version indicated in about is:
Version: 126.96.36.199 / LibreOffice Community
Build ID: 20(Build:1)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: fr-BE (fr_BE.utf8); UI: fr-FR
So I tried in B1
or with “m” or with “s”, but none functions.
Is there a difference of implantation between an LO English and LO French version?
I thought it was “merely” an question of translation.
More precisely, are they different datediff implementation according to LO builds?
How to get a date time difference across versions?