Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

12.07.2018 u 16:36, Michael D. Setzer II je napisao/la:
01/17/18 03:30 PM         01/17/18 03:30 PM
01/17/18 10:20 PM         01/17/18 10:20 PM
0:6:50:0                  0:06:50:00
Formula in A3

Nice! Thanks!

But makes me wonder what's wrong with


as it works well in Excel. Maybe I should file a feature request?


Formula in B3

I did include seconds, but you could remove the :S, and have options to
show 2 digits or just one. The #0 makes it print the 0, but ## would print
blank for zero values.

On 12 Jul 2018 at 13:42, Krunose wrote:

From:                   Krunose <>
Subject:                [libreoffice-users] Calculate difference between
two dates (with time)
Date sent:              Thu, 12 Jul 2018 13:42:36 +0200


just a quick question: if A1 holds 1.7.18. 15:30 and if A2 holds 1.7.18.
22:20, why then


returns 30:6:50 instead 0:6:50?



To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

  Michael D. Setzer II - Computer Science Instructor (Retired)
  Guam - Where America's Day Begins
  G4L Disk Imaging Project maintainer
+------------------------------------------------------------+ (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)


ROSETTA      65602903.467560 | ABC          16613838.513356
SETI        109419383.050719 | EINSTEIN    141198856.499240

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.