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

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

Subject:                Re: [libreoffice-users] Calculate difference 
between two dates (with
From:                   Robert Großkopf <>
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


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       
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.

LibreOffice Community:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

 Michael D. Setzer II - Computer Science Instructor (Retired)                    
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer
+------------------------------------------------------------+ (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)


ROSETTA      65604277.831505 | ABC          16613838.513356
SETI        109420652.286057 | EINSTEIN    141202628.499240

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


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.