Wednesday

July 23, 2014

July 23, 2014

Posted by **John** on Friday, June 28, 2013 at 9:55pm.

Let me try and explain this. So lets say cell A7B9 was Monday 3:00 P.M. - 7:00 P.M., the name in the cell was John Smith, the numerical value associated with the cell (that I would have to have predefined I assume some how) would be 4 (the total time of the shift). This would be done for every shift on the schedule. The system would then sum the total time for all shifts associated with a particular employee to get the employees expected weekly hour total for each employee.

Is there a way to do this in excel or perhaps another program which I can write a function like this?

Basically I want to be able to automatically calculate the total expected hours of all my employees in a week off of a schedule in an excel sheet. Cell include employees name if they are working the shift.

Thanks for any help!!!

- Excel -
**Writeacher**, Saturday, June 29, 2013 at 10:16amI know there's a way to do this, and it has to do with formulas and linking them from one worksheet to another. Read widely:

http://www.google.com/search?q=excel+formulas+link+from+one+sheet+to+another&oq=excel+formulas+link+&aqs=chrome.1.57j0l3.10365j0&sourceid=chrome&ie=UTF-8

**Related Questions**

MAths - Raoul wants to create a weekly schedule for going to the gym. He wants ...

mathss - Raoul wants to create a weekly schedule for going to the gym. He wants ...

AED 201 - Use a Microsoft® Excel or Word table function to propose and create a ...

economics - Each week, Bill, Mary and Jane select the quantity of two goods, x1 ...

Math - Over a four-week period, Gail earned the following commissions? Week 1 $...

math - To train for a triathlon Cartman swims 125m daily for one week.Each ...

post-secondary - What is a common schedule like in college or university? For ...

S.A.T Math - I do not understand This: Employee x is paid $12.50 an hour for the...

MAths algebra - ON day 1 each atheletic will begin the morning as follows Jog =3...

Data Analysis - You are a District sales manager and you are overloaded with ...