How do I turn off time auto-formating?

[moemoemoemoe]

In Libre Calc I enter 7:30, I want it to look like 7:30. Instead it looks like 07:30:00 AM. I tried going to Tools>Auto Correct Options and unchecking every single box and it still changes what I type.

Please give the user control back. Perhaps the most frustrating thing about using modern software is the programmers taking away control from the user. This is why I left windows and starting using linux.

BTW putting ’ in front of everything you type is not a solution, its a work around for poor design.

[Lupp]

This is not a case of formatting, but a case of recognition at first. Formatting of numeric values can only be applied to already entered or calculated values.

[anon87010807]

If I got it right, you just have to select the cells where you want to apply that formatting, then right click and select Format cells, then select Time and from Format the formatting that you want.

If this answer helped you, please vote it with (here on the left). That will help other people with the same question.

[Lupp]

As far as I know there is no “Time acceptance patterns” or something of the kind (fortunately?). TimeValues are recognised conforming with ISO 8601 where no TimeOfDay format is specified not starting with the hours part. Therefore you have to enter 0:7:30 if you mean the 7 coding for minutes and the 30 for seconds. Formatting the values for display you may then also use format codes like MM:SS or M:SS.
Be careful! These skew formats will suppress the hours part if present, and thus lie about the actual value. In my most recent version (V5.3.2) I can use [MM]:SS or [M]:SS to avoid this.