Entering times in a spreadsheet to totals hours, Minutes over a period. Sometimes a cell will have 01🕛46
instead of the 1:12:46 I entered. All cells are formatted time,HH:MM:SS
Hello,
this happens through replacement table in Tools -> AutoCorrect Options ...-> Tab: Replace
. There are a lot of entries similar to these:
I’d suggest to
- either disable use of replacement table in
Tools -> AutoCorrect Options ...-> Tab: Options -> Option: [] Use replacement table
- or delete the troubling entries from the replacement table
Hope that helps.
That once happened with a quite old version of LibreOffice that had :12:
and similar emoji replacements. You should upgrade anyway.