Time not displaying correctly

Issues with installing under all versions of MS Windows

Time not displaying correctly

Postby RUSSELL044 » Sun Jul 21, 2019 5:07 pm

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

Re: Time not displaying correctly

Postby FJCC » Sun Jul 21, 2019 6:28 pm

When you choose the format, what is the format code shown at the bottom of the dialog? It should be
HH:MM AM/PM
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7263
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Time not displaying correctly

Postby RUSSELL044 » Sun Jul 21, 2019 7:38 pm

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

Re: Time not displaying correctly

Postby RoryOF » Sun Jul 21, 2019 7:44 pm

Is the cell wide enough to display all characters of the time?
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29485
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Time not displaying correctly

Postby FJCC » Sun Jul 21, 2019 7:45 pm

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.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7263
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Time not displaying correctly

Postby RusselB » Sun Jul 21, 2019 7:49 pm

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 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
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
RusselB
Moderator
 
Posts: 5414
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Time not displaying correctly

Postby RUSSELL044 » Sun Jul 21, 2019 7:53 pm

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

Postby RUSSELL044 » Sun Jul 21, 2019 7:56 pm

Here is the worksheet.
Attachments
demo.ods
(9.76 KiB) Downloaded 12 times
demo.ods
(9.76 KiB) Downloaded 9 times
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

Postby FJCC » Sun Jul 21, 2019 8:10 pm

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?
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7263
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Time not displaying correctly

Postby RusselB » Sun Jul 21, 2019 8:13 pm

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 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
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
RusselB
Moderator
 
Posts: 5414
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Time not displaying correctly

Postby RUSSELL044 » Sun Jul 21, 2019 9:12 pm

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 8 times
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

Postby RoryOF » Sun Jul 21, 2019 9:16 pm

Just enter your times in full form: 08:55 AM rather than 8:55 a.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29485
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Time not displaying correctly

Postby RUSSELL044 » Sun Jul 21, 2019 9:21 pm

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

Re: Time not displaying correctly

Postby RoryOF » Sun Jul 21, 2019 9:30 pm

It's not the problem - enter your time in full format. OpenOffice is not an Excel clone.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29485
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Time not displaying correctly

Postby RUSSELL044 » Sun Jul 21, 2019 9:33 pm

Thank you all for taking the time to respond to my question.
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

Postby RusselB » Sun Jul 21, 2019 9:35 pm

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 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
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
RusselB
Moderator
 
Posts: 5414
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Time not displaying correctly

Postby Villeroy » Sun Jul 21, 2019 10:34 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27113
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Time not displaying correctly

Postby Bill » Mon Jul 22, 2019 12:23 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.

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.6 and LO 6.2.0.3 on Manjaro MATE
Bill
Volunteer
 
Posts: 7331
Joined: Sat Nov 24, 2007 6:48 am

Re: Time not displaying correctly

Postby MrProgrammer » Mon Jul 22, 2019 4:32 pm

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.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3815
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to MS Windows

Who is online

Users browsing this forum: No registered users and 6 guests