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

On Fri, 13 Jul 2018 14:10:38 +0100
Tom Davies <tomcecf@gmail.com> 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 as a whole.

That's simply not true. I just clicked on Reply to send this message,
and as you can see, it has been sent to the whole list.

You must be using a broken mailer.

> The only option offered by most email clients is the "Reply to all".
> Some specialist and rarely used email clients do offer a "Reply to
> group" but that is rarely needed for any other mailing list or
> anywhere so people are not used to using it, even if they are lucky
> enough to have the option available.
>
> This problem is compounded by the "Reply to all" putting the mailing
> list's address in the "CC" field instead of the "To".  This means
> that almost everyone is supposed to perform some dexterous
> cut&pasting for every single reply which is a real pita on a
> hand-held device and is not entirely easy on the most commonly used
> email clients.
>
> I think a lot of us have complained to the people who carefully
> set-up the mailing list to misbehave in this awkward and clumsy
> fashion but they claim that the majority of people prefer it this way.
>
> So we have had to learn to just delete twice or answer once and
> delete the second one or some-such.  Hitting the delete key really
> not that arduous surely?
> Regards from
> a Tom :)
>
>
>
>
>
>
> On 13 July 2018 at 13:48, Robert Großkopf <robert@familiegrosskopf.de>
> wrote:
>
> > 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
> > > >
> > > > 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.  
> >
> > OK, need the day as a separate value:
> > =ABRUNDEN(B1-A1)&":"&TEXT(B1-A1;"HH:MM")
> >
> > ABRUNDEN is the German Name for the function. Could be it is named
> > FLOOR in the English version.
> >
> > HH:MM gives the hours and minutes without the days.
> >
> > Regards
> >
> > Robert
> > --
> > Homepage: http://robert.familiegrosskopf.de
> > LibreOffice Community: http://robert.familiegrosskopf.de/map_3
> >
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > 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 


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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