Find and Copy
 

I have downloaded data from another program into excel and I just need a
total of the employee's hours worked. Here's how the data filled in the
spreadsheet:

Employee # Name Day Worked Hours Worked
001 May Smith Jan 1 8.0
Jan 2
8.0
Jan 10
7.0
Total
23.00

002 Jane Doe Jan 2 8.0
Jan 4 8.0
Jan 11 8.0
Total 24.0

Now - I want the data to look like this in the end -
Employee # Name Total Hours
001 Mary Smith 23
002 Jane Doe 24

How do I do that?

Find and Copy
 

"Help" wrote:

I have downloaded data from another program into excel and I just need a
total of the employee's hours worked. Here's how the data filled in the
spreadsheet:

# Name Day Hours Worked
001 May Smith Jan 1 8.0
Jan 2 8.0
Jan 10 7.0
Total 23.00

002 Jane Doe Jan 2 8.0
Jan 4 8.0
Jan 11 8.0
Total 24.0

Now - I want the data to look like this in the end -
# Name Total Hours
001 Mary Smith 23
002 Jane Doe 24

How do I do that?

Find and Copy
 

I'm sorry ignore this.. My formatting is showing up very well. I'll try
again on another message.

"Help" wrote:

I have downloaded data from another program into excel and I just need a
total of the employee's hours worked. Here's how the data filled in the
spreadsheet:

Employee # Name Day Worked Hours Worked
001 May Smith Jan 1 8.0
Jan 2
8.0
Jan 10
7.0
Total
23.00

002 Jane Doe Jan 2 8.0
Jan 4 8.0
Jan 11 8.0
Total 24.0

Now - I want the data to look like this in the end -
Employee # Name Total Hours
001 Mary Smith 23
002 Jane Doe 24

How do I do that?