Re: [libreoffice-users] Calculate difference between two dates (with time)

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