Hi Roger, thanks for your post, thats what I was looking for but I think for
our ludite users I will be better off with the drop down box, its bad enough
asking them to ctrl + s every 10 mins (I've now put it on auto) I think I'll
stick with whay I've got
Thanks

"Roger Govier" wrote:

Hi

I meant to add my post, you could also just enter Ctrl+Shift+ ; (that's
Ctrl+Shift +semicolon) to enter current Time to a cell.
That's probably just as quick as Alt,arrow,arrow,Enter.

--
Regards

Roger Govier


"swede" wrote in message
...
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