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.