Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and copy | Excel Discussion (Misc queries) | |||
Find and Copy | Excel Discussion (Misc queries) | |||
Find then copy | Excel Worksheet Functions | |||
find and copy | Excel Worksheet Functions | |||
Find and copy?? | Excel Worksheet Functions |