Re: [libreoffice-users] Reply, Reply all, Reply list, and getting offended (was Calculate difference between two,dates (with time))

2018-07-13 Thread Tom Davies
Hi :) +1 This mailing list is a gateway from the Microsquish world so we have got to be able to handle whatever systems MS users are using at any point in time. We cannot expect them to magically know all our individual pet hates. We cannot expect them to change ALL their systems at the same

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

2018-07-13 Thread Michael D. Setzer II
Think this gets the job done as I see it, but it is a somewhat complex process. Did the work at top of spreadsheet, but copied it a couple times, and then copied it to show formulas. Pasted into text editor, and changed spaces to _ and \t to ; Date_1;Date_2;Years;Month;Day;Hour;Minute;Second

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

2018-07-13 Thread Michael D. Setzer II
I was right about it not handling some dates, but was more complex than I though. Put in a date that was 1 second short of a year, and it was bad. This seems to resolve the issue. Might have more rows than needed, Since sometimes it has the correct results before the final row. Again, pasted

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 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 time)

2018-07-13 Thread Krunose
12.07.2018 u 22:52, libreoffice-ml.mbou...@spamgourmet.com je napisao/la: Krunose wrote: 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? Assuming those dates are 7th January

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

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 :) 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 Virgil Arrington
I'm with Tom on this one. If I click "Reply", it only goes to the individual sender, and not the list. On my phone, I can click "Reply All" as I have just done here, but Tom will get it twice. On my Linux Mint laptop with Thunderbird, I have a "Reply to List" option that only sends it to the

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

2018-07-13 Thread Michael D. Setzer II
=On 13 Jul 2018 at 15:11, Krunose wrote: Subject:;Re: [libreoffice-users] Calculate difference between two dates time) To:;users@global.libreoffice.org From:60;krunosekruno...@gmx.com Date sent:60;Fri, 13 Jul 2018 15:11:58 +0200 12.07.2018 u 22:52, libreoffice-ml.mbou...@spamgourmet.com je

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
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 Dave Howorth
So use Thunderbird on Mint and stop using your phone. Or take the trouble to edit recipients on your phone, or get a better mail app on your phone. FWIW, I use claws, which is available for a range of systems. Mails from this list include this header: List-Post:

[libreoffice-users] Reply, Reply all, Reply list, and getting offended (was Calculate difference between two,dates (with time))

2018-07-13 Thread Virgil Arrington
On 07/13/2018 12:57 PM, Dave Howorth wrote: > So use Thunderbird on Mint and stop using your phone. Or take the > trouble to edit recipients on your phone, or get a better mail app on > your phone. > > FWIW, I use claws, which is available for a range of systems. > > Mails from this list include