Time format

N

Neil Greenough

I have a cell which is formatted to time as hh:mm

Now, the user has to type the time in the above format, hh:mm as above.

Is it possible for me to allow the user to simply type in the time as hhmm
and then for the spreadsheet to automatically format it to hh:mm.

So for example, 08:30. I would like the user to be able to type in either
08:30 or 0830 and for the spreadsheet to recognise both entries and format
it to 08:30.

Any ideaS?
 
P

Pete

If the user entered data into another cell (formatted as text, perhaps
on another sheet), then you could construct a formula in this cell to
manipulate what has been entered - basically, if the data just entered
contains a colon then take that value, otherwise take the first two
characters, add a colon then add the last two characters and take the
numerical value of this combination. The cell with this formula in
should be formatted to show hh:mm.

Pete
 
Top