Ask Your Question

Format of time inside formula bar in Calc?

asked 2017-03-01 16:15:49 +0200

sdaau gravatar image

updated 2017-03-01 16:16:25 +0200

Consider this example (LOffice/Calc v

  • Open a new Calc document
  • select first cell, type in 12:31, then [ENTER]
  • Calc automatically shows it as 12:31:00 PM
  • Don't like this format, so select the cell, right-click, Format Cells... -> then choose Category: Time, Format: 13:37 (Format code: HH:MM), press OK
  • Now the cell itself is in 24h format

However, if I'd want to edit the cell from the formula bar, I can notice the format in the formula bar is still the same old one with AM/PM:


And this irritates me majorly, because I'm used to 24h display, and I tend to write say 13:00 in the bar (or cell), upon which I immediately get an error, since there is no 13 in 12h display.

So how can I change the default display of the formula bar to be 24h time display, so I can enter times like 13:00 or 19:12 without a problem?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-03-01 16:32:35 +0200

pierre-yves samyn gravatar image


I do not have this problem (my interface is in French) but I reproduce what you describe by selecting the English USA language (Format Cells> Numbers tab).

With my configuration selecting English (UK) solves the problem.



edit flag offensive delete link more


Fantastic, @pierre-yves samyn -> that worked great! First I selected the cell, right click Format Cells / Numbers and just changed Language to English (UK), whose default is HH;MM:SS and forced the formula bar to that display; then I reselected cell and applied HH:MM number format again, to have the same display as in OP - but the formula remained in 24h HH:MM:SS, which is great. Thanks for that, cheers!

sdaau gravatar imagesdaau ( 2017-03-01 16:48:17 +0200 )edit

"Fantastic,"? Absolutely fantastic it would be if the outdated and stubborn formats for dates and times finally vanished everywhere. The current state of "localization" is a mess anyway - and it is growing worse.
A first step of recovery might be an "ISO-locale" for Calc. No extras! Empty thesaurus, All 'Autocorrect' and 'Autotext' features off. What a wonderful world. I would even accept a decimal point. Despite ... Look at the date format used on the surface of this funny "forum". Oh my ...

Lupp gravatar imageLupp ( 2017-03-01 19:05:47 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-01 16:15:49 +0200

Seen: 248 times

Last updated: Mar 01 '17