| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Hybrid Mode
