Thanks very much Pete. Another thing learnt today. "Event procedures" Once
I'd de-formatted everything it worked a treat.

Cheers

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Pete_UK" wrote:

Check out Chip Pearson's site he

http://www.cpearson.com/excel/DateTimeEntry.htm

He gives a method for quick data entry where you do not have to input
the delimiters.

Hope this helps.

Pete


On Mar 11, 11:04 am, Russell Dawson
wrote:
I have a shared w/sheet that requires inputters to make a time entry of time
spent on a task.
Times can range from a matter of minutes to a couple of hours.

I'm Ok with formatting cells to time but what I want to do is ensure that
they correctly enter the time as say, 1:20 for 1 hour 20 mins which gives
01:20:00. Using data validation, I can ensure they do not input as 1.2 but
when the time is less than an hour, say 25 mins and it is wrongly entered .25
or 0.25 it does not prompt the inputter re incorrect input (0:25) and the
entry becomes 06:00:00.

Assistance would be much appreciated.

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.

.