Libre Office Calc 184.108.40.206.
I'd like to enter the time 5:39 in minutes and seconds in a cell. I highlight the cell and select Format > Cells from the menu. In the 'Format Cells' dialog, I enter
MM:SS in the 'Format code' box at the bottom and select 'OK'.
When I then enter '5:39' in the cell, it's immediately changed to '39:00'. If I instead enter the full HH:MM:SS value '00:05:39' in the cell, it does finally show up as '5:39'.
How do I format the cell so that I can type in exactly what I want it to show, which is the MM:SS format '5:39'?