change time from 12 hr to 24 hr system

Asked by Rudolf Harmsen on 2013-01-13

Using open office, I want to use 24 hour notations, like 16:30 instead of 04:30:00 pm. when I type in 16:30 it changes my entry into ### which I can only change into the longer old fashioned one. How do I reset this?

Question information

English Edit question
Ubuntu Edit question
No assignee Edit question
Last query:
Last reply:

Sure it's not libreoffice? Libreoffice is default in Ubuntu

Tony Pursell (ajpursell) said : #2

Hi Rudolf

As far as Is I can see, time INPUT is always 24hr, i.e 16:30.

What is DISPLAYED depends on the Cell format (Format > Cells.. or Right Click and choose Format Cells... then select Time)

Hope that helps


Can you help with this problem?

Provide an answer of your own, or ask Rudolf Harmsen for more information if necessary.

To post a message you must log in.