open the time formula automaticly in B1 after tabbing from A1

[Guest]

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

 

[Bob Phillips]

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)

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

 

[Guest]

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

 

[Roger Govier]

Hi

Works fine for me.
The cell with =NOW() I named as Time
In the column where entering times, I applied Data Validation>List>=Time
ALT,arrow,arrow,Enter works just fine

 

[Roger Govier]

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.

 

[Bob Phillips]

That is because your chance of getting exactly the same time as the dropdown
has (and don't forget NOW() includes the date), are very slight. Use Roger's
second suggestion.

--
HTH

Bob Phillips

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

 

[Guest]

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

 

[Guest]

Thanks Roger & Bob