James, Format thew column as time Select the column and query/replace a.m. with AM Select the column and query/replace p.m. with PM
Thats all. Success, Rob > Op 28 jun. 2023, om 23:31 heeft James <[email protected]> het volgende > geschreven: > > That seems to leave 11 pm as 11:00 (I expect 23:00). > Maybe I am doing it wrong. > > On 2023-06-28 17:10, Alan B wrote: >> Select the text fields, hopefully they are in a column or columns. >> >> After selecting the fields select "Data > Text to Columns..." from the menu >> >> In the Text to Columns dialog box select the following options: >> For "Separator Options" tick "Separated by". >> The only separator option that should be ticked is "Space". >> Be certain "Detect special numbers" is ticked in the "Other Options" >> choices. >> Click the "OK" button. >> >> The time portion of the column will now be a time formatted number in the >> column it was already in. Depending on the default format it may or may not >> have AM/PM. If it doesn't, just change the time format to what you need at >> this point. >> >> The "a.m." or "p.m." portion of your original text will be moved one column >> over. It will overwrite what is in the next column if the column is not >> empty. >> >> To prevent adjacent columns from being overwritten, while still in the >> "Text to Columns" dialog box, go to the "Fields" section at the bottom. >> >> There should be two columns with a heading of "Standard", one column >> showing the time portion of your text, the other column showing the a.m/p.m >> portion. Click the word "Standard" over the a.m/p.m column. >> >> Now open the "Column type" list and pick the "Hide" option. >> >> Finally, click OK to close the dialog box. >> >> You text time will now be a time number in the column it was already in. >> The a.m/p.m portion has not overwritten the adjacent column as it has been >> discarded as part of the Text to Columns operation. >> >> >> On Wed, Jun 28, 2023 at 4:32 PM James <[email protected]> wrote: >> >>> I have text fields like: >>> >>> 10:06:59 a.m. >>> 8:57:36 p.m. >>> >>> How do I convert them to 24-hour time fields? >>> -- >>> To unsubscribe e-mail to: [email protected] >>> 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: [email protected] > 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: [email protected] 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
