We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

jyoung's profile - activity

2020-09-02 09:03:20 +0200 received badge  Famous Question (source)
2020-01-01 07:44:35 +0200 received badge  Notable Question (source)
2020-01-01 03:53:12 +0200 marked best answer Calc fails to correctly format a date?

Hi everyone, I use Libre Calc 6.0.1.1 with Linux.

I'm trying to get a formatted delta time between two dates but I get result wrong. In cell A1 I put 31/12/19 13:20 (unformatted is 43830.5556815843) In cell A2 I put 02/01/20 14:00 (unformatted is 43832.5833333333)

the unformatted result is correct; cell A3 returns A2-A1 = 2.02765174899832 if I apply format DD HH:MM:SS result is 1 00:39:49 where obviously the time part is correct but the day part is wrong

Worse scenario is when I try to subtract 31/12/19 13:20 from 01/01/20 10:20. In this case the formatted result is 30 21:00:00 and not 0 21:00:00 as expected

There is a workaround by splitting the result into integer and fraction, keep integer as day and convert fraction to time and finally concatenate them, but is way so unproductive

Any guidelines what am I doing wrong or if this is a known bug?

Happy New Year to All Joe

2020-01-01 03:53:12 +0200 received badge  Scholar (source)
2019-12-31 19:29:23 +0200 received badge  Popular Question (source)