https://bugs.documentfoundation.org/show_bug.cgi?id=160408
--- Comment #6 from ady <[email protected]> --- (In reply to Ian Eales from comment #5) > I'm entering the data manually. Importing is no issue as I can format as > needed. Where is "importing" mentioned? Now I'm confused. > > There is no TIME format option in Tools... I checked before I wrote. Correct. That's why I did not point to it when talking about Time formats. OTOH, in comment 2 you seemed to imply that whichever Date format is set for the cell, the introduction in such format would be automatically recognized. In comment 4 I clarified that such assumption is not accurate. I have not tested whether changing the Date pattern recognition to use a Time-only format (that would be unique and not potentially parsed as any Date format) would work. > > If a column is a TIME 0000 format, it does recognize the decimal point part > of a DateTime. However, I'm not clever enough to do the math for 0413 > > However Date, Time and DateTime are three separate entities. TIME formatted > cells should understand Time in the field format. Simple alternative example A1: 0430 Column A is the "value introduction column"; typing-in the initial zero is optional; the column can be formatted as 0000, not as Time. B1: =RIGHT(A1;2) (this column could be set as hidden later-on) C1: =LEFT(A1;LEN(A1)-2) (this column could be set as hidden later-on) D1: =TIME(C1;B1;) Column D could be formatted with any time format you want, including HHMM. All this should had been part of <https://ask.libreoffice.org>, leaving this site for bug reports and enhancement requests. -- You are receiving this mail because: You are the assignee for the bug.
