Forum Discussion
Entering 24hr time values
Hi, My user wants to be able to enter 24hr times as "0900", "1245" without any other punctuation and have them convert to (or at least, be interpreted as) valid 24hr times (e.g. 09:00, 12:45). I ...
In the custom selection of formatting cells, enter 00\:00
You should now be able to enter “1300” and it will format as “13:00”