How Can I count disagreement??
 

Hello
I have a table. I don't know how is english name but I want polish name
( Tabela przestawna). I have a three columns in this sheet.

1 column - date
2 column - time (Minimum time)
3 column - time (Maximum time)

I want add a new column into sheet where I want count disagreement (
Columnt 3 - Column 2).
For example: 16:00 - 8:00 = 8h.

How Can I do it?

How Can I count disagreement??
 

=C2-B2

and copy down.

--
HTH

Bob Phillips

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

"tomeq" wrote in message
oups.com...
Hello
I have a table. I don't know how is english name but I want polish name
( Tabela przestawna). I have a three columns in this sheet.

1 column - date
2 column - time (Minimum time)
3 column - time (Maximum time)

I want add a new column into sheet where I want count disagreement (
Columnt 3 - Column 2).
For example: 16:00 - 8:00 = 8h.

How Can I do it?

How Can I count disagreement??
 

HI
I know Bob but isn't a good idea beacuse I have other colum (name =
surname). When I change surname, formula " = c2 - b2" don't count good,

Maybe other idea??


Bob Phillips napisal(a):
=C2-B2

and copy down.

--
HTH

Bob Phillips

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

"tomeq" wrote in message
oups.com...
Hello
I have a table. I don't know how is english name but I want polish name
( Tabela przestawna). I have a three columns in this sheet.

1 column - date
2 column - time (Minimum time)
3 column - time (Maximum time)

I want add a new column into sheet where I want count disagreement (
Columnt 3 - Column 2).
For example: 16:00 - 8:00 = 8h.

How Can I do it?

How Can I count disagreement??
 

Sorry, don't see the connection between previous description and "Name"
problem.

NickHK

"tomeq" wrote in message
ps.com...
HI
I know Bob but isn't a good idea beacuse I have other colum (name =
surname). When I change surname, formula " = c2 - b2" don't count good,

Maybe other idea??


Bob Phillips napisal(a):
=C2-B2

and copy down.

--
HTH

Bob Phillips

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

"tomeq" wrote in message
oups.com...
Hello
I have a table. I don't know how is english name but I want polish
name
( Tabela przestawna). I have a three columns in this sheet.

1 column - date
2 column - time (Minimum time)
3 column - time (Maximum time)

I want add a new column into sheet where I want count disagreement (
Columnt 3 - Column 2).
For example: 16:00 - 8:00 = 8h.

How Can I do it?

How Can I count disagreement??
 

Nor how you would expect column 3 - column 2 if one is text.

--
HTH

Bob Phillips

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

"NickHK" wrote in message
...
Sorry, don't see the connection between previous description and "Name"
problem.

NickHK

"tomeq" wrote in message
ps.com...
HI
I know Bob but isn't a good idea beacuse I have other colum (name =
surname). When I change surname, formula " = c2 - b2" don't count good,

Maybe other idea??


Bob Phillips napisal(a):
=C2-B2

and copy down.

--
HTH

Bob Phillips

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

"tomeq" wrote in message
oups.com...
Hello
I have a table. I don't know how is english name but I want polish
name
( Tabela przestawna). I have a three columns in this sheet.

1 column - date
2 column - time (Minimum time)
3 column - time (Maximum time)

I want add a new column into sheet where I want count disagreement (
Columnt 3 - Column 2).
For example: 16:00 - 8:00 = 8h.

How Can I do it?

How Can I count disagreement??
 

No
I don't want disagreement text - date.
I want count disagreement date - date, for example 16:00 - 8:00 = 8:00.

Have you got any ideas?

Bob Phillips napisal(a):
Nor how you would expect column 3 - column 2 if one is text.

--
HTH

Bob Phillips

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

"NickHK" wrote in message
...
Sorry, don't see the connection between previous description and "Name"
problem.

NickHK

"tomeq" wrote in message
ps.com...
HI
I know Bob but isn't a good idea beacuse I have other colum (name =
surname). When I change surname, formula " = c2 - b2" don't count good,

Maybe other idea??


Bob Phillips napisal(a):
=C2-B2

and copy down.

--
HTH

Bob Phillips

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

"tomeq" wrote in message
oups.com...
Hello
I have a table. I don't know how is english name but I want polish
name
( Tabela przestawna). I have a three columns in this sheet.

1 column - date
2 column - time (Minimum time)
3 column - time (Maximum time)

I want add a new column into sheet where I want count disagreement (
Columnt 3 - Column 2).
For example: 16:00 - 8:00 = 8h.

How Can I do it?

How Can I count disagreement??
 

In what way doesn't it count?

--
HTH

Bob Phillips

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

"tomeq" wrote in message
oups.com...
No
I don't want disagreement text - date.
I want count disagreement date - date, for example 16:00 - 8:00 = 8:00.

Have you got any ideas?

Bob Phillips napisal(a):
Nor how you would expect column 3 - column 2 if one is text.

--
HTH

Bob Phillips

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

"NickHK" wrote in message
...
Sorry, don't see the connection between previous description and
"Name"
problem.

NickHK

"tomeq" wrote in message
ps.com...
HI
I know Bob but isn't a good idea beacuse I have other colum (name =
surname). When I change surname, formula " = c2 - b2" don't count
good,

Maybe other idea??


Bob Phillips napisal(a):
=C2-B2

and copy down.

--
HTH

Bob Phillips

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

"tomeq" wrote in message
oups.com...
Hello
I have a table. I don't know how is english name but I want
polish
name
( Tabela przestawna). I have a three columns in this sheet.

1 column - date
2 column - time (Minimum time)
3 column - time (Maximum time)

I want add a new column into sheet where I want count
disagreement (
Columnt 3 - Column 2).
For example: 16:00 - 8:00 = 8h.

How Can I do it?