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
"=TEXT(INT(A2-A1),"#0")&":"&TEXT(((A2-A1)-INT(A2-A1)),"H:M:S")

Nice! Thanks!

But makes me wonder what's wrong with

       =TEXT((A2-A1);"d:h:m")

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

Kruno



Formula in B3
"=TEXT(INT(A2-A1),"#0")&":"&TEXT(((A2-A1)-INT(A2-A1)),"HH:MM:SS")    

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:

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

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?


Thanks,

Kruno


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

+------------------------------------------------------------+
  Michael D. Setzer II - Computer Science Instructor (Retired)
  mailto:mi...@guam.net
  mailto:msetze...@gmail.com
  Guam - Where America's Day Begins
  G4L Disk Imaging Project maintainer
  http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+

http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

BOINC@HOME CREDITS

ROSETTA      65602903.467560 | ABC          16613838.513356
SETI        109419383.050719 | EINSTEIN    141198856.499240



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Reply via email to