change time from 12 hr to 24 hr system

Asked by Rudolf Harmsen

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:
Revision history for this message
actionparsnip (andrew-woodhead666) said :

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

Revision history for this message
Tony Pursell (ajpursell) said :

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.