Time format

  • Thread starter Thread starter Neil Greenough
  • Start date Start date
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?
 
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
 
Back
Top