Tracking sheet help, i'm stuck.

I think we need (a lot) more detail than that.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Tracking sheet help, i'm stuck.

Example sheet 3 On Time Performance

A B C


Route 0-10 +10

535S 1 1
401S 1
535S 0
511S 0
404n 0
404s 0



Example sheet 2

A B C D E
F


Run Vehicle Time Actual Diff Schedule

924 0 4:48 4:59 0:11 535S0448
208 0 5:13 5:14 0:01 401S0459
904 0 5:18 5:20 0:02 535S0518
908 0 5:25 511S0518


Im using sheet 3 to record the on time performance according to the
scheduled time on sheet 2.
Sheet 2 is to record the times vehicles pass a specific location. Column C
is a set time, the vehicles are not allowed to pass until that time or later.
Column D is used to enter the actual time the vehicles pass.
Column E on sheet 2 is set =D-C to record the difference of set time and
actual time they pass. If the actual time the vehicles pass is within 0 thru
10 minutes of the set time I record this in sheet 3 column B. If the actual
time the vehicles pass is greater than 10 minutes I record this on sheet 3,
column C.
Im trying to have sheet 3 linked to sheet 2 so when the vehicles pass and
I enter the time on sheet 2 column D, sheet 3 will do the count from that
entry, and place the count in the proper column.

There is more info on this in my other post "Tracking sheet Help"

hope this makes sence. Also my time format is set to, Time 13:30


"Bob Phillips" wrote:

I think we need (a lot) more detail than that.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Tracking sheet help, i'm stuck.

0-10,

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20<=--"0:10"))

10

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20--"0:10"))

and just copy down.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Example sheet 3 On Time Performance

A B C


Route 0-10 +10

535S 1 1
401S 1
535S 0
511S 0
404n 0
404s 0



Example sheet 2

A B C D E
F


Run Vehicle Time Actual Diff Schedule

924 0 4:48 4:59 0:11 535S0448
208 0 5:13 5:14 0:01 401S0459
904 0 5:18 5:20 0:02 535S0518
908 0 5:25 511S0518


I'm using sheet 3 to record the on time performance according to the
scheduled time on sheet 2.
Sheet 2 is to record the times vehicles pass a specific location. Column C
is a set time, the vehicles are not allowed to pass until that time or
later.
Column D is used to enter the actual time the vehicle's pass.
Column E on sheet 2 is set =D-C to record the difference of set time and
actual time they pass. If the actual time the vehicle's pass is within 0
thru
10 minutes of the set time I record this in sheet 3 column B. If the
actual
time the vehicle's pass is greater than 10 minutes I record this on sheet
3,
column C.
I'm trying to have sheet 3 linked to sheet 2 so when the vehicle's pass
and
I enter the time on sheet 2 column D, sheet 3 will do the count from that
entry, and place the count in the proper column.

There is more info on this in my other post "Tracking sheet Help"

hope this makes sence. Also my time format is set to, Time 13:30


"Bob Phillips" wrote:

I think we need (a lot) more detail than that.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Tracking sheet help, i'm stuck.

Thank you for your reply. I don't know where to make the changes so it works
in my wookbook. confused about the sheet 3 and no sheet 2 in the formula. is
there a way I can modify what I have so far. This does very well in placing
the count in sheet 3 when I make an entry on sheet 2. But it only counts the
entry, not whether the entry is with in 10 minutes, or over 10 minutes.


=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(NOT(ISBLANK(LTC!$D$3:$D$192))))

sheet 2 is LTC. sheet 3 is OTP.

"Bob Phillips" wrote:

0-10,

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20<=--"0:10"))

10

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20--"0:10"))

and just copy down.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Example sheet 3 On Time Performance

A B C


Route 0-10 +10

535S 1 1
401S 1
535S 0
511S 0
404n 0
404s 0



Example sheet 2

A B C D E
F


Run Vehicle Time Actual Diff Schedule

924 0 4:48 4:59 0:11 535S0448
208 0 5:13 5:14 0:01 401S0459
904 0 5:18 5:20 0:02 535S0518
908 0 5:25 511S0518


I'm using sheet 3 to record the on time performance according to the
scheduled time on sheet 2.
Sheet 2 is to record the times vehicles pass a specific location. Column C
is a set time, the vehicles are not allowed to pass until that time or
later.
Column D is used to enter the actual time the vehicle's pass.
Column E on sheet 2 is set =D-C to record the difference of set time and
actual time they pass. If the actual time the vehicle's pass is within 0
thru
10 minutes of the set time I record this in sheet 3 column B. If the
actual
time the vehicle's pass is greater than 10 minutes I record this on sheet
3,
column C.
I'm trying to have sheet 3 linked to sheet 2 so when the vehicle's pass
and
I enter the time on sheet 2 column D, sheet 3 will do the count from that
entry, and place the count in the proper column.

There is more info on this in my other post "Tracking sheet Help"

hope this makes sence. Also my time format is set to, Time 13:30


"Bob Phillips" wrote:

I think we need (a lot) more detail than that.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Tracking sheet help, i'm stuck.

So far this works in column B.

=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192<=--"0:10"))


And this for column C.

=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192=--"0:10"))


On sheet 3 column B This counts all the left nubers that match from sheet 2,
then if the difference is more then 10 minutes it subtracts 1 from that count
and places 1 in column C. I like the way it works, but it defeats the purpose
of (NOT(ISBLANK(.
Is there a way to keep the (NOT(ISBLANK in the formula? (Notice I've changed
the column that the entry info comes from). Also column E in sheet 2 is set
up to - the difference from D & C,(=D-C). So it has entry's of ### until the
enrty is made in D.

"Bob Phillips" wrote:

0-10,

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20<=--"0:10"))

10

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20--"0:10"))

and just copy down.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Example sheet 3 On Time Performance

A B C


Route 0-10 +10

535S 1 1
401S 1
535S 0
511S 0
404n 0
404s 0



Example sheet 2

A B C D E
F


Run Vehicle Time Actual Diff Schedule

924 0 4:48 4:59 0:11 535S0448
208 0 5:13 5:14 0:01 401S0459
904 0 5:18 5:20 0:02 535S0518
908 0 5:25 511S0518


I'm using sheet 3 to record the on time performance according to the
scheduled time on sheet 2.
Sheet 2 is to record the times vehicles pass a specific location. Column C
is a set time, the vehicles are not allowed to pass until that time or
later.
Column D is used to enter the actual time the vehicle's pass.
Column E on sheet 2 is set =D-C to record the difference of set time and
actual time they pass. If the actual time the vehicle's pass is within 0
thru
10 minutes of the set time I record this in sheet 3 column B. If the
actual
time the vehicle's pass is greater than 10 minutes I record this on sheet
3,
column C.
I'm trying to have sheet 3 linked to sheet 2 so when the vehicle's pass
and
I enter the time on sheet 2 column D, sheet 3 will do the count from that
entry, and place the count in the proper column.

There is more info on this in my other post "Tracking sheet Help"

hope this makes sence. Also my time format is set to, Time 13:30


"Bob Phillips" wrote:

I think we need (a lot) more detail than that.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Tracking sheet help, i'm stuck.

Hi Dale
You don't need to use Not Isblank
You could just amend your first formula
=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192<=--"0:10"),--(LTC!$E$3:$E$192<""))

Obviously you don't need this in the second formula, as if the cells are
greater than 10 minutes, they cannot be blank.
--
Regards
Roger Govier

"Dale G" wrote in message
...
So far this works in column B.

=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192<=--"0:10"))


And this for column C.

=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192=--"0:10"))


On sheet 3 column B This counts all the left nubers that match from sheet
2,
then if the difference is more then 10 minutes it subtracts 1 from that
count
and places 1 in column C. I like the way it works, but it defeats the
purpose
of (NOT(ISBLANK(.
Is there a way to keep the (NOT(ISBLANK in the formula? (Notice I've
changed
the column that the entry info comes from). Also column E in sheet 2 is
set
up to - the difference from D & C,(=D-C). So it has entry's of ### until
the
enrty is made in D.

"Bob Phillips" wrote:

0-10,

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20<=--"0:10"))

10

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20--"0:10"))

and just copy down.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Example sheet 3 On Time Performance

A B C


Route 0-10 +10

535S 1 1
401S 1
535S 0
511S 0
404n 0
404s 0



Example sheet 2

A B C D E
F


Run Vehicle Time Actual Diff Schedule

924 0 4:48 4:59 0:11 535S0448
208 0 5:13 5:14 0:01 401S0459
904 0 5:18 5:20 0:02 535S0518
908 0 5:25 511S0518


I'm using sheet 3 to record the on time performance according to the
scheduled time on sheet 2.
Sheet 2 is to record the times vehicles pass a specific location.
Column C
is a set time, the vehicles are not allowed to pass until that time or
later.
Column D is used to enter the actual time the vehicle's pass.
Column E on sheet 2 is set =D-C to record the difference of set time
and
actual time they pass. If the actual time the vehicle's pass is within
0
thru
10 minutes of the set time I record this in sheet 3 column B. If the
actual
time the vehicle's pass is greater than 10 minutes I record this on
sheet
3,
column C.
I'm trying to have sheet 3 linked to sheet 2 so when the vehicle's pass
and
I enter the time on sheet 2 column D, sheet 3 will do the count from
that
entry, and place the count in the proper column.

There is more info on this in my other post "Tracking sheet Help"

hope this makes sence. Also my time format is set to, Time 13:30


"Bob Phillips" wrote:

I think we need (a lot) more detail than that.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Tracking sheet help, i'm stuck.

I gave that a try, & it still counts the lb. sign ####. When I run the mouse
over column E a window appears and the messages is, dates and times that are
negative or too lage to diplay as ###. maybe there is a way to set up the
formula to not count negative time or something like that. Or maybe I could
go back to using column D with NOT(ISBLANK, and use a formula that calculates
& IF D-C=between <0:10, and 0:10? what do you think? Possible?



A B C D E
F
Run Vehicle Time Actual Diff Schedule
924 0 4:48 4:59 0:11 535S0448
208 0 5:13 ### 401S0459
904 0 5:18 ### 535S0518
908 0 5:25 ### 511S0518











"Roger Govier" wrote:

Hi Dale
You don't need to use Not Isblank
You could just amend your first formula
=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192<=--"0:10"),--(LTC!$E$3:$E$192<""))

Obviously you don't need this in the second formula, as if the cells are
greater than 10 minutes, they cannot be blank.
--
Regards
Roger Govier

"Dale G" wrote in message
...
So far this works in column B.

=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192<=--"0:10"))


And this for column C.

=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192=--"0:10"))


On sheet 3 column B This counts all the left nubers that match from sheet
2,
then if the difference is more then 10 minutes it subtracts 1 from that
count
and places 1 in column C. I like the way it works, but it defeats the
purpose
of (NOT(ISBLANK(.
Is there a way to keep the (NOT(ISBLANK in the formula? (Notice I've
changed
the column that the entry info comes from). Also column E in sheet 2 is
set
up to - the difference from D & C,(=D-C). So it has entry's of ### until
the
enrty is made in D.

"Bob Phillips" wrote:

0-10,

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20<=--"0:10"))

10

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20--"0:10"))

and just copy down.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Example sheet 3 On Time Performance

A B C


Route 0-10 +10

535S 1 1
401S 1
535S 0
511S 0
404n 0
404s 0



Example sheet 2

A B C D E
F


Run Vehicle Time Actual Diff Schedule

924 0 4:48 4:59 0:11 535S0448
208 0 5:13 5:14 0:01 401S0459
904 0 5:18 5:20 0:02 535S0518
908 0 5:25 511S0518


I'm using sheet 3 to record the on time performance according to the
scheduled time on sheet 2.
Sheet 2 is to record the times vehicles pass a specific location.
Column C
is a set time, the vehicles are not allowed to pass until that time or
later.
Column D is used to enter the actual time the vehicle's pass.
Column E on sheet 2 is set =D-C to record the difference of set time
and
actual time they pass. If the actual time the vehicle's pass is within
0
thru
10 minutes of the set time I record this in sheet 3 column B. If the
actual
time the vehicle's pass is greater than 10 minutes I record this on
sheet
3,
column C.
I'm trying to have sheet 3 linked to sheet 2 so when the vehicle's pass
and
I enter the time on sheet 2 column D, sheet 3 will do the count from
that
entry, and place the count in the proper column.

There is more info on this in my other post "Tracking sheet Help"

hope this makes sence. Also my time format is set to, Time 13:30


"Bob Phillips" wrote:

I think we need (a lot) more detail than that.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Tracking sheet help, i'm stuck.

Hi
I realise now, that column is a formula, so it will never be blank.
Your formula in D must be
=C2-B2
Change it to
=IF(C2="",C2-B2)
Then there will be Nulls "" in the cells, not negative times, at the
Sumproduct should work
--
Regards
Roger Govier

"Dale G" wrote in message
...
I gave that a try, & it still counts the lb. sign ####. When I run the
mouse
over column E a window appears and the messages is, dates and times that
are
negative or too lage to diplay as ###. maybe there is a way to set up the
formula to not count negative time or something like that. Or maybe I
could
go back to using column D with NOT(ISBLANK, and use a formula that
calculates
& IF D-C=between <0:10, and 0:10? what do you think? Possible?



A B C D E
F
Run Vehicle Time Actual Diff Schedule
924 0 4:48 4:59 0:11 535S0448
208 0 5:13 ### 401S0459
904 0 5:18 ### 535S0518
908 0 5:25 ### 511S0518











"Roger Govier" wrote:

Hi Dale
You don't need to use Not Isblank
You could just amend your first formula
=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192<=--"0:10"),--(LTC!$E$3:$E$192<""))

Obviously you don't need this in the second formula, as if the cells are
greater than 10 minutes, they cannot be blank.
--
Regards
Roger Govier

"Dale G" wrote in message
...
So far this works in column B.

=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192<=--"0:10"))


And this for column C.

=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192=--"0:10"))


On sheet 3 column B This counts all the left nubers that match from
sheet
2,
then if the difference is more then 10 minutes it subtracts 1 from that
count
and places 1 in column C. I like the way it works, but it defeats the
purpose
of (NOT(ISBLANK(.
Is there a way to keep the (NOT(ISBLANK in the formula? (Notice I've
changed
the column that the entry info comes from). Also column E in sheet 2 is
set
up to - the difference from D & C,(=D-C). So it has entry's of ###
until
the
enrty is made in D.

"Bob Phillips" wrote:

0-10,

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20<=--"0:10"))

10

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20--"0:10"))

and just copy down.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Example sheet 3 On Time Performance

A B C


Route 0-10 +10

535S 1 1
401S 1
535S 0
511S 0
404n 0
404s 0



Example sheet 2

A B C D E
F


Run Vehicle Time Actual Diff Schedule

924 0 4:48 4:59 0:11 535S0448
208 0 5:13 5:14 0:01 401S0459
904 0 5:18 5:20 0:02 535S0518
908 0 5:25 511S0518


I'm using sheet 3 to record the on time performance according to the
scheduled time on sheet 2.
Sheet 2 is to record the times vehicles pass a specific location.
Column C
is a set time, the vehicles are not allowed to pass until that time
or
later.
Column D is used to enter the actual time the vehicle's pass.
Column E on sheet 2 is set =D-C to record the difference of set time
and
actual time they pass. If the actual time the vehicle's pass is
within
0
thru
10 minutes of the set time I record this in sheet 3 column B. If the
actual
time the vehicle's pass is greater than 10 minutes I record this on
sheet
3,
column C.
I'm trying to have sheet 3 linked to sheet 2 so when the vehicle's
pass
and
I enter the time on sheet 2 column D, sheet 3 will do the count from
that
entry, and place the count in the proper column.

There is more info on this in my other post "Tracking sheet Help"

hope this makes sence. Also my time format is set to, Time 13:30


"Bob Phillips" wrote:

I think we need (a lot) more detail than that.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Tracking sheet help, i'm stuck.

=IF(D3="","",D3-C3)
=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192<=--"0:10"),--(LTC!$E$3:$E$192<""))
=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192=--"0:10"),--(LTC!$E$3:$E$192<""))
Thank you, works like a charm. This suff is fun.

"Roger Govier" wrote:

Apologies, missed out part.
That should have read
=IF(C2="","",C2-B2)


--
Regards
Roger Govier

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi
I realise now, that column is a formula, so it will never be blank.
Your formula in D must be
=C2-B2
Change it to
=IF(C2="",C2-B2)
Then there will be Nulls "" in the cells, not negative times, at the
Sumproduct should work
--
Regards
Roger Govier

"Dale G" wrote in message
...
I gave that a try, & it still counts the lb. sign ####. When I run the
mouse
over column E a window appears and the messages is, dates and times that
are
negative or too lage to diplay as ###. maybe there is a way to set up
the
formula to not count negative time or something like that. Or maybe I
could
go back to using column D with NOT(ISBLANK, and use a formula that
calculates
& IF D-C=between <0:10, and 0:10? what do you think? Possible?



A B C D E
F
Run Vehicle Time Actual Diff Schedule
924 0 4:48 4:59 0:11 535S0448
208 0 5:13 ### 401S0459
904 0 5:18 ### 535S0518
908 0 5:25 ### 511S0518











"Roger Govier" wrote:

Hi Dale
You don't need to use Not Isblank
You could just amend your first formula
=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192<=--"0:10"),--(LTC!$E$3:$E$192<""))

Obviously you don't need this in the second formula, as if the cells are
greater than 10 minutes, they cannot be blank.
--
Regards
Roger Govier

"Dale G" wrote in message
...
So far this works in column B.

=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192<=--"0:10"))


And this for column C.

=SUMPRODUCT(--(LEFT(LTC!$F$3:$F$192,4)=OTP!A8),--(LTC!$E$3:$E$192=--"0:10"))


On sheet 3 column B This counts all the left nubers that match from
sheet
2,
then if the difference is more then 10 minutes it subtracts 1 from
that
count
and places 1 in column C. I like the way it works, but it defeats the
purpose
of (NOT(ISBLANK(.
Is there a way to keep the (NOT(ISBLANK in the formula? (Notice I've
changed
the column that the entry info comes from). Also column E in sheet 2
is
set
up to - the difference from D & C,(=D-C). So it has entry's of ###
until
the
enrty is made in D.

"Bob Phillips" wrote:

0-10,

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20<=--"0:10"))

10

=SUMPRODUCT(--(Sheet3!$E$2:$E$20<""),--(LEFT(Sheet3!$F$2:$F$20,LEN($A2))=$A2),--(Sheet3!$E$2:$E$20--"0:10"))

and just copy down.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Example sheet 3 On Time Performance

A B C


Route 0-10 +10

535S 1 1
401S 1
535S 0
511S 0
404n 0
404s 0



Example sheet 2

A B C D E
F


Run Vehicle Time Actual Diff Schedule

924 0 4:48 4:59 0:11 535S0448
208 0 5:13 5:14 0:01 401S0459
904 0 5:18 5:20 0:02 535S0518
908 0 5:25 511S0518


I'm using sheet 3 to record the on time performance according to
the
scheduled time on sheet 2.
Sheet 2 is to record the times vehicles pass a specific location.
Column C
is a set time, the vehicles are not allowed to pass until that time
or
later.
Column D is used to enter the actual time the vehicle's pass.
Column E on sheet 2 is set =D-C to record the difference of set
time
and
actual time they pass. If the actual time the vehicle's pass is
within
0
thru
10 minutes of the set time I record this in sheet 3 column B. If
the
actual
time the vehicle's pass is greater than 10 minutes I record this on
sheet
3,
column C.
I'm trying to have sheet 3 linked to sheet 2 so when the vehicle's
pass
and
I enter the time on sheet 2 column D, sheet 3 will do the count
from
that
entry, and place the count in the proper column.

There is more info on this in my other post "Tracking sheet Help"

hope this makes sence. Also my time format is set to, Time 13:30


"Bob Phillips" wrote:

I think we need (a lot) more detail than that.

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
Tracking sheet help, i'm stuck.