If I format a cell as Time hh:mm:ss and enter a value containing a minute value 12 or less the value is displayed with a CLOCK symbol where minutes should be shown. For example when entering cell value 01:12:25 results in 01🕛:25
As a workaround change cell format to Time hh:mm, enter the hours and minutes (01:12). Change format back to hh:mm:ss and edit the cell to include the seconds. Now it shows 01:12:25 correctly.
Or, format as hh:mm:ss and enter 01:13:25. Then edit cell to desired value 01:12:25.
Steps to Reproduce:
1. Format a cell as Time hh:mm:ss
2. Enter a minute value of 12 or less
01🕛:25 is displayed
User Profile Reset: No
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
Thanks for reporting the issue.
This is caused by certain autocorrect entries, and is fixed in LibreOffice 5.2 to not interfere with time entry. As a workaround hitting Ctrl-Z right after the substitution undoes it, or the offending autocorrect entries can be removed as described here:
*** This bug has been marked as a duplicate of bug 97191 ***