Question
I have my employee schedule in a excel sheet. It is a weekly schedule that doesn't change week by week, but changes day by day within a week. Every Monday, Tuesday, etc. is the same schedule. In the file are days for Monday, Tuesday, etc.. I don't know if this possible, but I would like to utilize excel to calculate a employees total expected hours automatically. I however have no idea how to do this in excel and am not exactly sure how.
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!!!
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!!!
Answers
Writeacher
I 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
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
Raoul wants to create a weekly schedule for going to the gym. He wants to go to the gym the same thr...
An airline has 82% of its flights to par on schedule it has 65% of its flights departing arrive on s...
You use the IP Schedule Tool to keep track of your work schedule. What options are available to you...