Sunday
March 29, 2015

Homework Help: Excel

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

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!!!

Answer this Question

First Name:
School Subject:
Answer:

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 ...
programming - How do you write a program that prints out your course schedule ...
Math - Linda jogs every 3rd day and swims every 4th day. If she is jogging on ...
Fund of programming 1 - Write a program that prints out your course schedule for...
Sales - •Jim, Juan, Mary, and John are all managers for the same company •Jim ...
AED 201 - Use a Microsoft® Excel or Word table function to propose and create a ...
Math - Jim, Juan, Mary, and John are all managers for the same company •Jim ...
Math For Educators - A homeowner empties her hot water heater every 36 days and...
math - trina works after school and on weekends. she always works three days ...

Members