software

Hi All

I have a question which i am hoping someone will eb able to help me
with, i have a spreadsheet which contains infromation for part time
hours worked during the course of a month for individuals (e.g. below)

Name Start End Hours
Persona 1:30 2:30 1
Persona 3:30 4:30 1
Persona 9:30 11:30
person b
person b
person c
person c
person d etc etc

What i need is a formula that will allo wme to add an extra column
which gives me the total hours person a worked, person be worked and so
on. The original data contains multiple lines (i.e persona could have
10 lines, personb15 lines etc etc), and is used for temporay teachers
that may work different hours and days in a month. In other words as
below

NAme Start End Hours DAte Total
Person a 11:30 14:30 3 1/3/06
Person a 10:30 12:30 2 4/3/06
Person a 16:30 20:30 4 5/3/06 9
Person b 09:30 13:30 4 13/03/06
person b 08:30 11:30 3 01/03/06 7
and so on

any help is appreciate, and i hope the above makes senseHi Fudge,

you can e.g. use the SUMIF function
like:
you type in a cell (somewhere next to the database, but not connecting to it
lt;= practical advice or even in a summary spreadsheet)
x2: persona y2: SUMIF(a:a;x2;d:d)
x3: personb y3: SUMIF(a:a;x3;d:d)
x4: personc y4: SUMIF(a:a;x3;d:d) lt;= function can be copied
etc

where a:a is the column with the names (MUST be the same with x2, x3, x4...)
d:d is the column with the hours to be added

and X2, x3, x4 ... are the teachers names, only once per person.
this can be developed to more sophisticated tables :-)
Any good?
Best regards,
ANdras
(Hungary)

quot;Fudgequot; wrote:

gt; Hi All
gt;
gt; I have a question which i am hoping someone will eb able to help me
gt; with, i have a spreadsheet which contains infromation for part time
gt; hours worked during the course of a month for individuals (e.g. below)
gt;
gt; Name Start End Hours
gt; Persona 1:30 2:30 1
gt; Persona 3:30 4:30 1
gt; Persona 9:30 11:30
gt; person b
gt; person b
gt; person c
gt; person c
gt; person d etc etc
gt;
gt; What i need is a formula that will allo wme to add an extra column
gt; which gives me the total hours person a worked, person be worked and so
gt; on. The original data contains multiple lines (i.e persona could have
gt; 10 lines, personb15 lines etc etc), and is used for temporay teachers
gt; that may work different hours and days in a month. In other words as
gt; below
gt;
gt; NAme Start End Hours DAte Total
gt; Person a 11:30 14:30 3 1/3/06
gt; Person a 10:30 12:30 2 4/3/06
gt; Person a 16:30 20:30 4 5/3/06 9
gt; Person b 09:30 13:30 4 13/03/06
gt; person b 08:30 11:30 3 01/03/06 7
gt; and so on
gt;
gt; any help is appreciate, and i hope the above makes sense
gt;
gt;

Hi Andras

thansk fro your response, but im not quite sure what you mean.ANdras wrote:

gt; Hi Fudge,
gt;
gt; you can e.g. use the SUMIF function
gt; like:
gt; you type in a cell (somewhere next to the database, but not connecting to it
gt; lt;= practical advice or even in a summary spreadsheet)
gt; x2: persona y2: SUMIF(a:a;x2;d:d)
gt; x3: personb y3: SUMIF(a:a;x3;d:d)
gt; x4: personc y4: SUMIF(a:a;x3;d:d) lt;= function can be copied
gt; etc
gt;
gt; where a:a is the column with the names (MUST be the same with x2, x3, x4...)
gt; d:d is the column with the hours to be added
gt;
gt; and X2, x3, x4 ... are the teachers names, only once per person.
gt; this can be developed to more sophisticated tables :-)
gt; Any good?
gt; Best regards,
gt; ANdras
gt; (Hungary)
gt;
gt; quot;Fudgequot; wrote:
gt;
gt; gt; Hi All
gt; gt;
gt; gt; I have a question which i am hoping someone will eb able to help me
gt; gt; with, i have a spreadsheet which contains infromation for part time
gt; gt; hours worked during the course of a month for individuals (e.g. below)
gt; gt;
gt; gt; Name Start End Hours
gt; gt; Persona 1:30 2:30 1
gt; gt; Persona 3:30 4:30 1
gt; gt; Persona 9:30 11:30
gt; gt; person b
gt; gt; person b
gt; gt; person c
gt; gt; person c
gt; gt; person d etc etc
gt; gt;
gt; gt; What i need is a formula that will allo wme to add an extra column
gt; gt; which gives me the total hours person a worked, person be worked and so
gt; gt; on. The original data contains multiple lines (i.e persona could have
gt; gt; 10 lines, personb15 lines etc etc), and is used for temporay teachers
gt; gt; that may work different hours and days in a month. In other words as
gt; gt; below
gt; gt;
gt; gt; NAme Start End Hours DAte Total
gt; gt; Person a 11:30 14:30 3 1/3/06
gt; gt; Person a 10:30 12:30 2 4/3/06
gt; gt; Person a 16:30 20:30 4 5/3/06 9
gt; gt; Person b 09:30 13:30 4 13/03/06
gt; gt; person b 08:30 11:30 3 01/03/06 7
gt; gt; and so on
gt; gt;
gt; gt; any help is appreciate, and i hope the above makes sense
gt; gt;
gt; gt;Hi Fudge

Supposing your data is on Sheet1, with name in column A and Hours worked
in column D.
On sheet2, enter in column A a list of the individual names for which
you wish to summarise the data.
On sheet2 in cell B1 enter
=SUMIF(Sheet1!A:A,A1,Sheet1!D)
Copy the formula down column B for as many rows as you have entries in
column A.

--
Regards

Roger Govierquot;Fudgequot; gt; wrote in message oups.com...
gt; Hi Andras
gt;
gt; thansk fro your response, but im not quite sure what you mean.
gt;
gt;
gt; ANdras wrote:
gt;
gt;gt; Hi Fudge,
gt;gt;
gt;gt; you can e.g. use the SUMIF function
gt;gt; like:
gt;gt; you type in a cell (somewhere next to the database, but not
gt;gt; connecting to it
gt;gt; lt;= practical advice or even in a summary spreadsheet)
gt;gt; x2: persona y2: SUMIF(a:a;x2;d:d)
gt;gt; x3: personb y3: SUMIF(a:a;x3;d:d)
gt;gt; x4: personc y4: SUMIF(a:a;x3;d:d) lt;= function can be copied
gt;gt; etc
gt;gt;
gt;gt; where a:a is the column with the names (MUST be the same with x2, x3,
gt;gt; x4...)
gt;gt; d:d is the column with the hours to be added
gt;gt;
gt;gt; and X2, x3, x4 ... are the teachers names, only once per person.
gt;gt; this can be developed to more sophisticated tables :-)
gt;gt; Any good?
gt;gt; Best regards,
gt;gt; ANdras
gt;gt; (Hungary)
gt;gt;
gt;gt; quot;Fudgequot; wrote:
gt;gt;
gt;gt; gt; Hi All
gt;gt; gt;
gt;gt; gt; I have a question which i am hoping someone will eb able to help me
gt;gt; gt; with, i have a spreadsheet which contains infromation for part time
gt;gt; gt; hours worked during the course of a month for individuals (e.g.
gt;gt; gt; below)
gt;gt; gt;
gt;gt; gt; Name Start End Hours
gt;gt; gt; Persona 1:30 2:30 1
gt;gt; gt; Persona 3:30 4:30 1
gt;gt; gt; Persona 9:30 11:30
gt;gt; gt; person b
gt;gt; gt; person b
gt;gt; gt; person c
gt;gt; gt; person c
gt;gt; gt; person d etc etc
gt;gt; gt;
gt;gt; gt; What i need is a formula that will allo wme to add an extra column
gt;gt; gt; which gives me the total hours person a worked, person be worked
gt;gt; gt; and so
gt;gt; gt; on. The original data contains multiple lines (i.e persona could
gt;gt; gt; have
gt;gt; gt; 10 lines, personb15 lines etc etc), and is used for temporay
gt;gt; gt; teachers
gt;gt; gt; that may work different hours and days in a month. In other words
gt;gt; gt; as
gt;gt; gt; below
gt;gt; gt;
gt;gt; gt; NAme Start End Hours DAte Total
gt;gt; gt; Person a 11:30 14:30 3 1/3/06
gt;gt; gt; Person a 10:30 12:30 2 4/3/06
gt;gt; gt; Person a 16:30 20:30 4 5/3/06 9
gt;gt; gt; Person b 09:30 13:30 4 13/03/06
gt;gt; gt; person b 08:30 11:30 3 01/03/06 7
gt;gt; gt; and so on
gt;gt; gt;
gt;gt; gt; any help is appreciate, and i hope the above makes sense
gt;gt; gt;
gt;gt; gt;
gt;