Hi Michael,
Le 07/07/2020 à 14:34, Michael Tiernan a écrit :
On 7/2/20 2:06 PM, Michael D. Setzer II wrote:
I've been trying to take a formula that calculates the difference
between to
dates into years/months/days.
I'll ask if anyone has a macro or formulae that would do almost the same
sent:Wed, 08 Jul 2020 03:12:21 +1000
Subject:Re: [libreoffice-users] Strange question on
Macro?? (in Spreadsheet)
Priority:normal
Did a test with the following:
In cell A1 =int(now())
in cell A2 =A1+time(1,12,0)
In cell B2 =Datedif($a$1,a2,d)'get days diff
in cellC2 =A2-$A$1'gets HH:MM:SS
with a second. Probable the rounding factor of second
portion??
Hope that gives and ideal.Note thespacein E2 formula.
Good Luck.
On 7 Jul 2020 at 8:34, Michael Tiernan wrote:
From:Michael tiernanmichael.tier...@gmail.com
Subject:Re: [libreoffice-users] Strange question on
Macro?? (in Spreadsheet
On 7/2/20 2:06 PM, Michael D. Setzer II wrote:
I've been trying to take a formula that calculates the difference between to
dates into years/months/days.
I'll ask if anyone has a macro or formulae that would do almost the same
thing but allow it to be expressed further out to include "hours"