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


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")  

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.se@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+unsubscribe@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:mikes@guam.net                            
 mailto:msetzerii@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+unsubscribe@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

Context


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.