If you want time displayed in 24 hour format:
FORMAT => CELL => TIME => choose 13:37:46
QED.
Joe
On 6/28/23 16:55, James wrote:
I created a spreadsheet with 3 columns:
a1 -> 11:28
b1 -> p.m.
c1 -> =IFS(B1="p.m.",A1+24,A1+24)
c1 always displays 11:28
On 2023-06-28 17:10, Alan B wrote:
Don't know where you are on this at the moment but, apologies, I overlooked
using the a.m./p.m. indicator in the text string.
A solution that does not overlook that is to use a formula in an adjacent
cell to convert the text value to a time value and then format that time
value to display as you
Done.
On 2023-06-28 17:09, Steve Edmonds wrote:
It depends how you want the sheet to function. If you use Edit>Find
and Replace... find a.m. replace with AM, find p.m. replace with PM it
automatically converts.
On 29/06/2023 08:31, James wrote:
I have text fields like:
10:06:59 a.m.
I created a spreadsheet with 3 columns:
a1 -> 11:28
b1 -> p.m.
c1 -> =IFS(B1="p.m.",A1+24,A1+24)
c1 always displays 11:28
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
detect special numbers looks checked but I can't uncheck it.
I looked at it to see if it was the problem with converting text to columns.
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
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 het volgende
> geschreven:
>
> That seems to leave 11 pm as 11:00 (I expect 23:00).
> Maybe I
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 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
It depends how you want the sheet to function. If you use Edit>Find and
Replace... find a.m. replace with AM, find p.m. replace with PM it
automatically converts.
On 29/06/2023 08:31, James 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
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: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
I decided many years ago to stick with my distributions (SUSE) packaging
of LO, not for the ease of installation but for the ease of uninstalling
and rollback (a 2 minute job) when I encountered an issue in LO that
interrupted my work flow and then roll forward again when the issue was
I have been using Libre Office for many years without any problems, and
since 2020 on a Mac book.
Over recent months the second level of the menu has stopped working:
Eg. I cannot turn tracked changes on and off. I click "Edit" and the drop
down menu appears, I click "Track Changes" and the side
12 matches
Mail list logo