In libreoffice calc (currently using 126.96.36.199) I would like to use custom date and time formats in cells as follows:
Date: YYYYMMDD, that is without separators between year, month and day, eg 20171130.
Time: HHMM with 0-24 h scale without separator between hour and minutes, eg 2132
I tried to set the above formats in format/cells/numbers/category date and time respectively but it doesn’t work.
For date it accepts my custom format YYYYMMDD if I type it in the format code field, and it can be saved. But if I enter a date in a cell formatted with my custom format the date changes strangely, eg if I type in the cell 20171130, it becomes -84100904 after hitting enter.
For time formats it even doesn’t accept my custom HHMM time fromat. If I type my custom format code in the format code field, the category changes (from time) to user-defined.
What is the solution for this?