Re: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days lapsed between a "from a date" cell and a "to a date' cell
Hi :) Thanks Andreas. It works! There are all sorts of neat tricks but that is the fastest way to enter dates. I hope that helps our op. Thanks and regards from Tom :) --- On Tue, 24/1/12, Andreas Säger wrote: From: Andreas Säger Subject: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days lapsed between a "from a date" cell and a "to a date' cell To: users@global.libreoffice.org Date: Tuesday, 24 January, 2012, 14:38 Am 24.01.2012 15:17, Tom Davies wrote: > Hi :) > I think for data-entry it is best to enter the date as > 01/24/2012 If you want to enter dates of the current month (January 2012 at the time of this writing) then you simply enter 1/ 13/ 4/ 30/ 15/ This will enter the *correct cell values* _unless_ the cells had been formatted as text *before* entry. If there are some February dates: 1/2 3/2 28/2 except for the US locale where you type 2/1 3/2 2/28 Of course you can enter full dates with long or short month name, but why? How exactly the correct cell values look like depends firstly on the locale setting, secondly on the number format. Once you entered the correct cell values, there are literally thousands of ways to change the appearance of these values (dozends of predefined formats for each locale plus user-defined formats). Once you entered the correct cell values, no formatting attribute will ever change your value, not even number format "Text" (which many users believe to be a magic conversion feature). > I'm in England so it feels a tad weird to type the day and month 'the wrong > way around', lol. I think it picks-up on whatever your global localisation > is set at. Mine is set to UK so i type dd/mm/. > Regards from This global setting applies to all types of table cells (Writer, Calc, Base), Writer fields, Calc cell styles, form controls (Base), numeric chart axes and may be more. All of these elements have a cell format dialog where you can override the locale for the current element. You can change it for the current Calc document by changing the locale of the default cell style which propagates to all subsequent styles which do not have an explicit locale setting. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days lapsed between a "from a date" cell and a "to a date' cell
Hi :) I think for data-entry it is best to enter the date as 01/24/2012 and then have the cells formatted to display that in whichever way you want. It feels a bit weird to enter a date as numbers and then see it displayed as word&numbers but doing it that way makes everything else fall into place neatly. I'm in England so it feels a tad weird to type the day and month 'the wrong way around', lol. I think it picks-up on whatever your global localisation is set at. Mine is set to UK so i type dd/mm/. Regards from Tom :) --- On Tue, 24/1/12, MSwhip wrote: From: MSwhip Subject: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days lapsed between a "from a date" cell and a "to a date' cell To: users@global.libreoffice.org Date: Tuesday, 24 January, 2012, 12:58 This is my reply to all of you that made suggestions or stated your views. They were all very useful. With regards to the question about what exactly I was asking, the first issue was ...should I enter the date as "24 January 2012," or "January 24 2012" or '01/24/2012' or 24/01/2012 for the software to take it as a number to be deducted from the number represention the second date input of another cell to form the "from date1 to date2" proposition for it to come up with the number of days between those 2 dates? The second issue was the actual way to enter a formula to get the actual number od days between the 2 cells involved. Hope I made myself totally clear now. Thank you -- View this message in context: http://nabble.documentfoundation.org/How-to-enter-Dates-in-a-format-to-allow-the-counting-of-days-lapsed-between-a-from-a-date-cell-and-al-tp3671720p3684597.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days lapsed between a "from a date" cell and a "to a date' cell
Hi: You only have to input like this example: in cell A1 : 10/12/2011 in cell B1 : 12/12/2011 in cell C1 : +B1-A1 ---> Result = 2 in cell C1 Regards, Jorge Rodríguez ___ El jue, 19-01-2012 a las 08:25 -0800, Tom escribió: > Hi :) > I think you are not fully subscribed to the list yet. Is there a > "confirmation email" waiting in your spam/junk folder? > > Don't you just format the cells as Dates rather than numbers or text and > then just do one cell - the other and have the answer cell formatted as date > too? > Regards from > Tom :) > > -- > View this message in context: > http://nabble.documentfoundation.org/How-to-enter-Dates-in-a-format-to-allow-the-counting-of-days-lapsed-between-a-from-a-date-cell-and-al-tp3671720p3672798.html > Sent from the Users mailing list archive at Nabble.com. > -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: Re: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days lapsed
Unsubscribe me please! The unsubscribe procedure does not work! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days lapsed between a "from a date" cell and a "to a date' cell
Here is how I do it. I use Column A for the beginning date,Column B for the ending date, and Row 1 for the column headings. I enter the first beginning date in cell A2 and first ending date in cell B2. I continue adding the beginning and ending dates down these two columns. In cell C2, I enter this formula: =B2-A2. That is I enter the equal sign followed by B2 followed by a minus sign followed by A2. Use the Enter key to enter this formula into cell C2. Click cell C2, and you should see a little box at the bottom right of the outline of this cell. Use the mouse cursor to drag it down column C until you come to the last pair of beginning and ending dates. This will give you the number of days that exist between each pair of dates. --Dan On Thu, 2012-01-19 at 08:25 -0800, Tom wrote: > Hi :) > I think you are not fully subscribed to the list yet. Is there a > "confirmation email" waiting in your spam/junk folder? > > Don't you just format the cells as Dates rather than numbers or text and > then just do one cell - the other and have the answer cell formatted as date > too? > Regards from > Tom :) > > -- > View this message in context: > http://nabble.documentfoundation.org/How-to-enter-Dates-in-a-format-to-allow-the-counting-of-days-lapsed-between-a-from-a-date-cell-and-al-tp3671720p3672798.html > Sent from the Users mailing list archive at Nabble.com. > -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
