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

2018-07-13 Thread Dave Howorth
On Fri, 13 Jul 2018 18:17:47 + Virgil Arrington wrote: > Chill, Dave Goodbye, Virgil. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

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

2018-07-13 Thread Virgil Arrington
Chill, Dave Sent from my Verizon, Samsung Galaxy smartphone Original message From: Dave Howorth Date: 7/13/18 11:59 AM (GMT-06:00) To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Calculate difference between two dates (with time) So use Thunderbird

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

2018-07-13 Thread Dave Howorth
uot;Reply to List" option that > only sends it to the list. > > Virgil > > > Sent from my Verizon, Samsung Galaxy smartphone > > Original message > From: Tom Davies > Date: 7/13/18 9:55 AM (GMT-06:00) > To: Dave Howorth > Cc: users@global

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

2018-07-13 Thread Virgil Arrington
t" option that only sends it to the list. Virgil Sent from my Verizon, Samsung Galaxy smartphone Original message From: Tom Davies Date: 7/13/18 9:55 AM (GMT-06:00) To: Dave Howorth Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Calculate difference between two

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

2018-07-13 Thread Tom Davies
Hi :) Wow!! That is the first time anyone has said that on this mailing list afaik Are you using Thunderbird or "The Bat!" or what? Regards from a Tom :) On 13 July 2018 at 15:13, Dave Howorth wrote: > On Fri, 13 Jul 2018 14:10:38 +0100 > Tom Davies wrote: > > > Hi :) > > It is the design

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

2018-07-13 Thread Dave Howorth
On Fri, 13 Jul 2018 14:10:38 +0100 Tom Davies wrote: > Hi :) > It is the design of the mailing list. It's designed so that people > can't just "reply to" in order to reply to the whole mailing list. > Clicking on "reply to" makes the reply private so that it can't be > seen by the mailing list

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

2018-07-13 Thread Tom Davies
Hi :) It is the design of the mailing list. It's designed so that people can't just "reply to" in order to reply to the whole mailing list. Clicking on "reply to" makes the reply private so that it can't be seen by the mailing list as a whole. The only option offered by most email clients is

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

2018-07-13 Thread Robert Großkopf
Hi michael, at first: Why do you answer to the list, some other persons and my private mail-address? I am reading and writing the the list and doens#T need the same message twice. >> >> I have tried it with German date-time-values and have set only >> =A2 - A1 >> ... and it returns 06:50:00 >> >>

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

2018-07-13 Thread Michael D. Setzer II
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 Date sent: Fri, 13 Jul 2018 07:56

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

2018-07-13 Thread Robert Großkopf
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

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

2018-07-12 Thread Krunose
12.07.2018 u 16:36, Michael D. Setzer II je napisao/la: 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")&":"(((A2-A1)-INT(A2-A1)),"H:M:S") Nice! Thanks! But makes me wonder what's

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

2018-07-12 Thread Michael D. Setzer II
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")&":"(((A2-A1)-INT(A2-A1)),"H:M:S") Formula in B3 "=TEXT(INT(A2-A1),"#0")&":"(((A2-A1)-INT(A2-A1)),"HH:MM:SS") I did include