Time not displaying correctly

Issues with installing under all versions of MS Windows
Post Reply
RUSSELL044
Posts: 7
Joined: Sun Jul 21, 2019 4:50 pm

Time not displaying correctly

Post by RUSSELL044 »

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
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Time not displaying correctly

Post by FJCC »

When you choose the format, what is the format code shown at the bottom of the dialog? It should be
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.
RUSSELL044
Posts: 7
Joined: Sun Jul 21, 2019 4:50 pm

Re: Time not displaying correctly

Post by RUSSELL044 »

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
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Time not displaying correctly

Post by RoryOF »

Is the cell wide enough to display all characters of the time?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Time not displaying correctly

Post by FJCC »

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.
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Time not displaying correctly

Post by RusselB »

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.
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.
RUSSELL044
Posts: 7
Joined: Sun Jul 21, 2019 4:50 pm

Re: Time not displaying correctly

Post by RUSSELL044 »

I think I was able to upload the file showing what it looks like.
Attachments
Openoffice.JPG
OpenOffice ver is 4.1.6 and my OS is windows 10
RUSSELL044
Posts: 7
Joined: Sun Jul 21, 2019 4:50 pm

Re: Time not displaying correctly

Post by RUSSELL044 »

Here is the worksheet.
Attachments
demo.ods
(9.76 KiB) Downloaded 185 times
demo.ods
(9.76 KiB) Downloaded 159 times
OpenOffice ver is 4.1.6 and my OS is windows 10
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Time not displaying correctly

Post by FJCC »

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.
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Time not displaying correctly

Post by RusselB »

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
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.
RUSSELL044
Posts: 7
Joined: Sun Jul 21, 2019 4:50 pm

Re: Time not displaying correctly

Post by RUSSELL044 »

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 177 times
OpenOffice ver is 4.1.6 and my OS is windows 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Time not displaying correctly

Post by RoryOF »

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
RUSSELL044
Posts: 7
Joined: Sun Jul 21, 2019 4:50 pm

Re: Time not displaying correctly

Post by RUSSELL044 »

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
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Time not displaying correctly

Post by RoryOF »

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
RUSSELL044
Posts: 7
Joined: Sun Jul 21, 2019 4:50 pm

Re: Time not displaying correctly

Post by RUSSELL044 »

Thank you all for taking the time to respond to my question.
OpenOffice ver is 4.1.6 and my OS is windows 10
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Time not displaying correctly

Post by RusselB »

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
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.
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Time not displaying correctly

Post by Villeroy »

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.
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
Bill
Volunteer
Posts: 8932
Joined: Sat Nov 24, 2007 6:48 am

Re: Time not displaying correctly

Post by Bill »

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.
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".

Format numbers as dates or times
AOO 4.1.14 on Ubuntu MATE 22.04
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Time not displaying correctly

Post by MrProgrammer »

RUSSELL044 wrote:So would appreciate any advice on how this be corrected.
Select the cells, Edit → Find & Replace → More options
deselect Match casedeselect 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).
Post Reply