Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

According to what @SM_Riga said, you could do like this: before you start entering data, the date cell should be empty, choose user defined format by right click > format cell > date > NN HH:MM, now you can and have to enter a valid date like 15.04.2019 07:58, with hitting enter it will render to Mo 07:58 allthough it still contains a valid date. Now it's a date value, it lets you sort this very easy.

C:\fakepath\Unbenannt 1.ods

According to what @SM_Riga said, you could do like this: before you start entering data, the date cell should be empty, choose user defined format by right click > format cell > date > NN HH:MM, now you can and have to enter a valid date like 15.04.2019 07:58, with hitting enter it will render to Mo 07:58 allthough although it still contains a valid date. Now it's a date value, it lets you sort this very easy.

C:\fakepath\Unbenannt 1.ods