<0,D26+12,D26)-(E26<0);"=IF(E26<0,DA
Y($B$2),E26)-(F26<0);"=IF(F26<0,F26+24,F26)-(G26<0);"=IF(H22<0,G26-1,
G26);"=IF(H26<0,H26+60,H26)
;;"=IF(D27<0,C27-1,C27);"=IF(D27<0,D27+12,D27)-(E27<0);"=IF(E27<0,DA
Y($B$2),E27)-(F27<
her
changes? Will have to look at it more, but would do most.
On 13 Jul 2018 at 15:11, Krunose wrote:
Subject:Re: [libreoffice-users] Calculate difference
between two dates time)
To: users@global.libreoffice.org
From: Krunose
Date sent:
=On 13 Jul 2018 at 15:11, Krunose wrote:
Subject:;Re: [libreoffice-users] Calculate difference
between two dates time)
To:;users@global.libreoffice.org
From:60;krunosekruno...@gmx.com
Date sent:60;Fri, 13 Jul 2018 15:11:58 +0200
12.07.2018 u 22:52, libreoffice-ml.mbou...@spamgourmet.com je
12.07.2018 u 22:52, libreoffice-ml.mbou...@spamgourmet.com je napisao/la:
Krunose wrote:
Hi,
just a quick question: if A1 holds 1.7.18. 15:30 and if A2 holds
1.7.18. 22:20, why then
=TEXT((A2-A1);"d:h:m")
returns 30:6:50 instead 0:6:50?
Assuming those dates are 7th January 2018
Krunose wrote:
Hi,
just a quick question: if A1 holds 1.7.18. 15:30 and if A2 holds 1.7.18.
22:20, why then
=TEXT((A2-A1);"d:h:m")
returns 30:6:50 instead 0:6:50?
Assuming those dates are 7th January 2018, since your mail headers
indicate you're using a US locale...
2018-01-0