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

  • Thread starter Thread starter cheri
  • Start date Start date
C

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
 
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)
 
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)
 
Back
Top