2009/12/8 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). 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. 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. Not what you are looking for, I know, but as far as I can get without using extra cells and things like that… Johnny Rosenberg > > > -- > 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]
