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