>> I have a column formatted as "HH:MM". When the user enters "14" I need >> it to be registered as "14:00" assuming a 24-hour clock. How can this >> be achieved? Thanks. > > As far as I know you can't to that. Entering 14 means day 14, which is > the same as 1900-01-13 00:00:00 (ISO8601 style date format). >
Really, is there no input mask or such? > If you want hours, minutes and anything less than one 24 hour period > (called ”1 dygn” in Swedish, by the way - English lacks a proper word > for it, I think), numbers < 1 are required. For example: Input > ”=14/24” in a cell formatted as ”HH:MM” and the cell will display > 14:00. > In Hebrew we also have the word for 24-hour period. An online dictionary translates it as: nf. a whole day (24 hours) Do other spreadsheets work like this? I will file a feature request as entering hours into a spreadsheet seem like it would be a rather common operation. > If you can accept a few more characters than just ”14”, you should > know that you don't need 00 for the minutes; 14:0 will work. Or 14:7 > for 14:07 and so on. > It is not much more practical, but thanks for the idea. > Not what you are looking for, I know, but as far as I can get without > using extra cells and things like that… > That would be getting too complicated for what surely _should_ be a simple procedure. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
