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

On 13 Jul 2018 at 7:56, Robert Großkopf wrote:

Subject:                Re: [libreoffice-users] Calculate difference 
between two dates (with
        time)
To:                     users@global.libreoffice.org
From:                   Robert Großkopf <robert@familiegrosskopf.de>
Date sent:              Fri, 13 Jul 2018 07:56:17 +0200

> Hi Krunose,
> > just a quick question: if A1 holds 1.7.18. 15:30 and if A2 holds 1.7.18.
> > 22:20, why then
>
> Did you type it right here? Point after 18? Dont know if this is a right
> format for a date/time-value.
>
> I have tried it with German date-time-values and have set only
> =A2 - A1
> ... and it returns 06:50:00
>
> Regrads
>
> Robert
That would give difference in hours only, but would not give the days
This is cells L1-M7 Right of ___ is column M contents.

01/17/18 03:30 PM       
01/28/18 12:20 PM       
10:20:50:0______"=TEXT(INT(L2-L1),"#0")&":"&TEXT(((L2-L1)-INT(L2-L1)),"
H:M:S")
08:50:00 PM_____________        L2-L1 Format Time/AM/PM
20:50:00________________        L2-L1 Format Hour Minute Secound
17______________________        "=INT(L1)-DATE(YEAR(L1),1,1)+1
28______________________        "=INT(L1)-DATE(YEAR(L1),1,1)+1

I also entered dates as the cells L1 and L2 shows, but did use the 24 hour 
format for the time, but it changed to AM/PM format by default. Some locals 
use the . instead of /, so whatever matches with setup.

Added the Julian Date calculation did earlier, but modified to use int, since L1 
and L2 have a time value included.


> -- 
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
>
>
> -- 
> 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      65604277.831505 | ABC          16613838.513356
SETI        109420652.286057 | EINSTEIN    141202628.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