Re: [libreoffice-users] Calculate difference between two dates (with time)
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.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Calculate difference between two dates (with time)
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 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: <mailto:users@global.libreoffice.org> and that tells your mail program that it should reply to the list. So the list is not broken, your mailer is if it doesn't. Oh, and please do take the trouble to NOT send me an extra copy if you want me not to block mails from you. On Fri, 13 Jul 2018 15:05:08 + Virgil Arrington wrote: > 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 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 > dates (with time) > > 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 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 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 :) -- 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.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- 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.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Calculate difference between two dates (with time)
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: <mailto:users@global.libreoffice.org> and that tells your mail program that it should reply to the list. So the list is not broken, your mailer is if it doesn't. Oh, and please do take the trouble to NOT send me an extra copy if you want me not to block mails from you. On Fri, 13 Jul 2018 15:05:08 + Virgil Arrington wrote: > 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 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 > dates (with time) > > 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 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 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 :) -- 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.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Calculate difference between two dates (with time)
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 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 dates (with time) 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 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 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 > > 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)&":"(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+unsubscr...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] Calculate difference between two dates (with time)
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 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 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 > > 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)&":"(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+unsubscr...@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+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] Calculate difference between two dates (with time)
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 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 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 > 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)&":"(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+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] Calculate difference between two dates (with time)
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 "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 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 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)&":"(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+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] Calculate difference between two dates (with time)
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)&":"(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+unsubscr...@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
Re: [libreoffice-users] Calculate difference between two dates (with time)
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: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 > > 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. 01/17/18 03:30 PM 01/28/18 12:20 PM 10:20:50:0__"=TEXT(INT(L2-L1),"#0")&":"(((L2-L1)-INT(L2-L1))," H:M:S") 08:50:00 PM_L2-L1 Format Time/AM/PM 20:50:00L2-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. > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > > > -- > 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.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 65604277.831505 | ABC 16613838.513356 SETI109420652.286057 | EINSTEIN141202628.499240 -- 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.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Calculate difference between two dates (with time)
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 Regrads Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- 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.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Calculate difference between two dates (with time)
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 wrong with =TEXT((A2-A1);"d:h:m") as it works well in Excel. Maybe I should file a feature request? Kruno Formula in B3 "=TEXT(INT(A2-A1),"#0")&":"(((A2-A1)-INT(A2-A1)),"HH:MM:SS") 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: 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 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/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 ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 65602903.467560 | ABC 16613838.513356 SETI109419383.050719 | EINSTEIN141198856.499240 -- 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.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Calculate difference between two dates (with time)
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 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: 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 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/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 ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 65602903.467560 | ABC 16613838.513356 SETI109419383.050719 | EINSTEIN141198856.499240 -- 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.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy