Timesheet calculation

[anorth]

I have created a timesheet for engineers working for
different clients correlated to different job numbers.

I have created an hours worked calculation for each day
and these results are displayed in a cell.

I need excel to add up for each engineers weekly hours
worked, results per job number. We can then cost per job
his weekly hours.

Can anyone help.

Alan North

 

[Frank Kabel]

Hi
if column A conmatins the job number and column B the
hours try
=SUMIF(A:A,"job_number",B:B)
and format this resulting cell with the custom format
[hh]:mm

For further calculations multiply this value with 24 to
get the hours in a decimal form

 

[anorth]

Thanks Frank but.......

Job numbers work on a sequential basis and change week by
week, will this search all job numbers that are identical
without inputting specifics??

Regards

Alan

-----Original Message-----
Hi
if column A conmatins the job number and column B the
hours try
=SUMIF(A:A,"job_number",B:B)
and format this resulting cell with the custom format
[hh]:mm

For further calculations multiply this value with 24 to
get the hours in a decimal form

-----Original Message-----
I have created a timesheet for engineers working for
different clients correlated to different job numbers.

I have created an hours worked calculation for each day
and these results are displayed in a cell.

I need excel to add up for each engineers weekly hours
worked, results per job number. We can then cost per job
his weekly hours.

Can anyone help.

Alan North
.

.