On 13 Jul 2018 at 7:56, Robert Großkopf wrote:
Subject: Re: [libreoffice-users] Calculate difference
between two dates (with
time)
To: [email protected]
From: Robert Großkopf <[email protected]>
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: [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 65604277.831505 | ABC 16613838.513356
SETI 109420652.286057 | EINSTEIN 141202628.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
