open the time formula automaticly in B1 after tabbing from A1
 

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

open the time formula automaticly in B1 after tabbing from A1
 

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

open the time formula automaticly in B1 after tabbing from A1
 

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

open the time formula automaticly in B1 after tabbing from A1
 

Hi

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


--
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

open the time formula automaticly in B1 after tabbing from A1
 

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

open the time formula automaticly in B1 after tabbing from A1
 

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)

"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

open the time formula automaticly in B1 after tabbing from A1
 

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

open the time formula automaticly in B1 after tabbing from A1
 

Thanks Roger & Bob

"swede" wrote:

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