Timesheet calculation

  • Thread starter Thread starter anorth
  • Start date Start date
A

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
 
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
 
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
.
Click to expand...
.
Click to expand...
 
Back
Top