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: [email protected]
From: Krunose <[email protected]>
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: [email protected]
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:[email protected]
mailto:[email protected]
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: [email protected]
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
