Excel

posted by .

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

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. AED 201

    Use a Microsoft® Excel or Word table function to propose and create a schedule of school-related tasks for a typical teaching day from the time you arrive at school until the time you leave school at the end of the day. Remember to …
  2. programming

    How do you write a program that prints out your course schedule for a week?
  3. Fund of programming 1

    Write a program that prints out your course schedule for a single week. Here's an example of the output for one day: Monday 9:00 Computer Science 101 Monday 11:00 Physics 201 Monday 2:00 Dance 153
  4. statistics

    ) The personnel manager of a consumer products company asked a random sample of 300 employees how they felt about how they felt about going to a flex schedule, which would allow employees to choose their arrival and leaving times, …
  5. MAths algebra

    ON day 1 each atheletic will begin the morning as follows Jog =3/2miles, walk=7/4 miles,Rest=5/2 minutes?
  6. MAths

    Raoul wants to create a weekly schedule for going to the gym. He wants to go to the gym the same three days each week, and he wants there to be at least one day in between each of his visits. How many different ways can Raoul schedule …
  7. mathss

    Raoul wants to create a weekly schedule for going to the gym. He wants to go to the gym the same three days each week, and he wants there to be at least one day in between each of his visits. How many different ways can Raoul schedule …
  8. Math

    Linda jogs every 3rd day and swims every 4th day. If she is jogging on Monday, what day of the week will she end up jogging and swimming?
  9. Sales

    •Jim, Juan, Mary, and John are all managers for the same company •Jim always meets the sales goals •Juan exceeded the goal by 15% on Tuesday and 10% on Wednesday. •Mary’s goals for each day of the week are 5% lower than the …
  10. Math

    To make evening schedule.... Need 12 employees on monday.. 13 on tues.. 14 on wed... 15 on thurs.. 17 on fri... 16 on sat... 14 on sun... They on can work 4.5 hrs a day ... How many employees needed for week?

More Similar Questions