Hi Bob, I'm a bit of a novice, but I used the NOW formula which gave me
present date and time and the used validation on my main sheet. I now get a
drop down box with 1 time/date (whatever the computer time is) it works
brilliant but just time comsuming when you have to go back to the mouse

"Bob Phillips" wrote:

What are your time periods and how did you create them? If you just created
a list by typing a couple in and copying those down, you might find that
Excel's floating point engine is hurting you. Create a formula to build
exact values in the list and use that.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"swede" wrote in message
...
I have made a hospital porter tracking spreasheet. I have drop down
colomns
with, where the porter is going (from and to) and the porter who is doing
the
job and colomns with the now formula, which I have used validation for
them
all. I can type in the data which is in the drop down boxes and tab to the
next cell, but have to use the mouse to click on the time. I can use the
shortcut (alt -arrow-arrow-enter-tab) for the time but is there a way of
opening the time after tabbing from the cell which has the porter in it
(which starts the job) Phew!! I know what I mean but does anybody else!
Help