2009/12/10 Dotan Cohen <[email protected]>: >>> 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?
No, I think you should use Base for that. Actually I filed a request for enhancement in this matter (input mask) a few years ago, but obviously the priority of this is not too high… > > >> 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 think Excel did too, but I haven't used Excel in years, so I can't say anything about more recent versions. > I will file a feature request as > entering hours into a spreadsheet seem like it would be a rather > common operation. Maybe that's what I already did a couple of years ago… Johnny Rosenberg > > >> 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
