complicated function in excel

G

Guest

I have a schedule spreadsheet that I modified that has the times listed
across the top and you type the employees name in each hour cell and at the
end it totals the hours worked. (FORMULA IS: =SUM(IF(ISTEXT(C6:K6),1,0)) )
I want to add a page that will "find" the employees names on each of 7 pages
(one for each day of the week)and their hours worked and total them on the
last page. Let me know if it would be helpful to send you the sheet. Thanks
in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

time sheets 6
Add Time Q 4
Adding up total hours worked on employee schedule using various criteria 0
Function to calculate total hours worked in one week. 4
Time Totals in a Workbook 1
Help with IF function 3
Creating a formula in Excel 1
formula explanation 3

Top