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: https://wiki.documentfound

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 on

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

2018-07-13 Thread Dave Howorth
a "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: us

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 betwee

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 a

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 the

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-12 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 ret

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

2018-07-12 Thread Krunose
") 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:

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

2018-07-12 Thread Michael D. Setzer II
To: users@global.libreoffice.org From: Krunose 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 hold

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

2018-07-12 Thread Krunose
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+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help