Pop up clock to enter in the time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all

Does anyone know how to insert a pop up clock to enter in a time. Or, another way absolute way to eliminate possible user errors such not entering the am/pm, or putting a ";" instead of ":"? Thanks.
 
Hi
you may use 'Data - Validation' and allow only dates to be entered for
these specific cells
 
They need to be free to enter any time that is necessary. Will be used by people with ,in general, low computer skill so I need away to eliminate all possible user errors
 
You could have a couple of spinners, and use one for the hours, one for the
minutes, and use them to update a cell. Very simple, very visual, and the
user can't do it wrongly.

--

HTH

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

kstar said:
They need to be free to enter any time that is necessary. Will be used by
people with ,in general, low computer skill so I need away to eliminate all
possible user errors
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top