Selecting a Time in a cell w/out inputting the data

[cheri]

Hello,

I am creating a time sheet for our employees to clock in and out of
What I want to do is set up each cell for the Start Time, Lunch Out
Lunch In and End Time so the employee has choices of the hours broke
down in fifteen minute intervals to select from without typing in th
hours.

What I would really like is to create a time clock similar to the P
time clock in the right hand corner where you can change the tim
accordingly. I'm really not sure if this is possilbe of how to do thi
so I am hoping some one can help me.

If the above is not possible then how can I create a drop down windo
showing all the hours based on military time? The only way that I kno
how to do this is data validation; is this the only way to do this?

Thank you so much for your help!
Cher

 

[Bob Phillips]

Hi Cheri,

You could do it with a simple couple of spinners, one for the hours, one for
the minutes.

It's VBA, but quite simple. Let me know if you want an example.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[cheri]

Hi Bob,

I would love to know how. Please send me a sample.

Thank you so much,
Cher

 

[Bob Phillips]

I'll need your email address if you want a sample.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)