Time not displaying correctly
-
- Posts: 7
- Joined: Sun Jul 21, 2019 4:50 pm
Time not displaying correctly
I am using OpenOffice 4.1.6. I formatted column to display time as 9:00 AM. Going to format time, I click the format I want to use, ( 01:37 AM ). But when entering time into the cells, it displays as 9 A. This issue just started today. Up to now, it would display correctly. Even created a new worksheet formatting cells for time. Still same result. So would appreciate any advice on how this be corrected.
OpenOffice ver is 4.1.6 and my OS is windows 10
Re: Time not displaying correctly
When you choose the format, what is the format code shown at the bottom of the dialog? It should be
HH:MM AM/PM
HH:MM AM/PM
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
-
- Posts: 7
- Joined: Sun Jul 21, 2019 4:50 pm
Re: Time not displaying correctly
That is what I see in the format code box.
Last edited by RUSSELL044 on Sun Jul 21, 2019 7:47 pm, edited 1 time in total.
OpenOffice ver is 4.1.6 and my OS is windows 10
Re: Time not displaying correctly
Is the cell wide enough to display all characters of the time?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Time not displaying correctly
Please upload a small file showing the problem. To upload a file, click Post Reply and look for the Upload Attachment tab just below the box where you type a response.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Time not displaying correctly
You have stated what you see, but we can't actually see it.. unless you upload/attach a screenshot.
Even then, for diagnostic reasons, it's better for you to attach a copy of your spreadsheet, rather than a screenshot.
To attach a file (spreadsheet or screenshot), use the PostReply button, which will allow you access to the Upload attachment tab, which, in turn, will allow you to pick the file to attach to this topic.
Even then, for diagnostic reasons, it's better for you to attach a copy of your spreadsheet, rather than a screenshot.
To attach a file (spreadsheet or screenshot), use the PostReply button, which will allow you access to the Upload attachment tab, which, in turn, will allow you to pick the file to attach to this topic.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
-
- Posts: 7
- Joined: Sun Jul 21, 2019 4:50 pm
Re: Time not displaying correctly
I think I was able to upload the file showing what it looks like.
OpenOffice ver is 4.1.6 and my OS is windows 10
-
- Posts: 7
- Joined: Sun Jul 21, 2019 4:50 pm
Re: Time not displaying correctly
Here is the worksheet.
OpenOffice ver is 4.1.6 and my OS is windows 10
Re: Time not displaying correctly
All of the cells in column C contain text, not numbers. You can see this by selecting the menu View -> Value Highlighting. Cells in black are text. If you enter 0.75 in C8, it will appear as 06:00 PM, as expected. Where did the contents of column C come from?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Time not displaying correctly
The entries in your "time" column are text. They will not be affected by the number formatting.
In order to the number formatting to be applied, you have to enter the time as a number. eg: 7:00 for 7:00 AM, or 19:00 for 7:00 PM or 7:00 pm for 7:00 pm
Entering the information correctly, along with the settings you are showing, should resolve the problem
In order to the number formatting to be applied, you have to enter the time as a number. eg: 7:00 for 7:00 AM, or 19:00 for 7:00 PM or 7:00 pm for 7:00 pm
Entering the information correctly, along with the settings you are showing, should resolve the problem
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
-
- Posts: 7
- Joined: Sun Jul 21, 2019 4:50 pm
Re: Time not displaying correctly
I am sorry, I just started using OpenOffice within the past few days. Have been using Microsoft Office 365. The data that is in column C was entered manually. For example: I would type 8:55 p for 8:55 PM, 9 a for 9:00 AM. I am sending the first worksheet I created a few last week.
- Attachments
-
- BP.ods
- (23.88 KiB) Downloaded 182 times
OpenOffice ver is 4.1.6 and my OS is windows 10
Re: Time not displaying correctly
Just enter your times in full form: 08:55 AM rather than 8:55 a.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
-
- Posts: 7
- Joined: Sun Jul 21, 2019 4:50 pm
Re: Time not displaying correctly
Just thought of something, and am not sure this is the issue. I did a recovery couple days ago and had to re-download the software again and reinstall it.
OpenOffice ver is 4.1.6 and my OS is windows 10
Re: Time not displaying correctly
It's not the problem - enter your time in full format. OpenOffice is not an Excel clone.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
-
- Posts: 7
- Joined: Sun Jul 21, 2019 4:50 pm
Re: Time not displaying correctly
Thank you all for taking the time to respond to my question.
OpenOffice ver is 4.1.6 and my OS is windows 10
Re: Time not displaying correctly
If it was working for you using 8:55 a rather than 8:55 am, then it was, imo, a fluke, as the normal operation would take the 8:55 a as text, since the AM is missing to tell Calc that you are working with a time.
Just add the letter m at the end of each time entry, so that you get 8:55 am or 8:55 pm (rather than 8:55 a or 8:55 p) will resolve this problem and make your entries consistent with what Calc is expecting for a time entry
Just add the letter m at the end of each time entry, so that you get 8:55 am or 8:55 pm (rather than 8:55 a or 8:55 p) will resolve this problem and make your entries consistent with what Calc is expecting for a time entry
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Time not displaying correctly
Another spreadsheet formatted to death.
Stop using any formatting attributes and take care of the cell values. Centered content makes it difficult to distinuguish numbers from text.
With completely unformatted cells and in US English context:
23: enters 11pm
11: enters 11 am
23/ enters this month's 23th day
12/23 enters this year's 23rd of December (US context only)
If the values are right, you may format them any way you like later. But first you need correct cell values before anything else.
Stop using any formatting attributes and take care of the cell values. Centered content makes it difficult to distinuguish numbers from text.
With completely unformatted cells and in US English context:
23: enters 11pm
11: enters 11 am
23/ enters this month's 23th day
12/23 enters this year's 23rd of December (US context only)
If the values are right, you may format them any way you like later. But first you need correct cell values before anything else.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Time not displaying correctly
MS Excel accepts "8:55 p" as a time value. AOO Calc and LO Calc do not. When using Calc, you have to enter the time as "8:55 pm".RUSSELL044 wrote:I am sorry, I just started using OpenOffice within the past few days. Have been using Microsoft Office 365. The data that is in column C was entered manually. For example: I would type 8:55 p for 8:55 PM, 9 a for 9:00 AM.
Format numbers as dates or times
AOO 4.1.14 on Ubuntu MATE 22.04
- MrProgrammer
- Moderator
- Posts: 4896
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Time not displaying correctly
Select the cells, Edit → Find & Replace → More optionsRUSSELL044 wrote:So would appreciate any advice on how this be corrected.
→ deselect Match case → deselect Entire cells → select Current selection only
→ Search for a → Replace with am → Replace All
→ Search for p → Replace with pm → Replace All.
I recommend unchecking Current selection only before clicking Close.
8L12 P appears to be a typing error; fix it manually.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).