total hours

[robert220]

i'm working on a schedule for my wife i have everything setup where she can choose from a list of empoyees and the time frames she needs, and at that point it caculates the total hours scheduled for that day and time off, then totals weekly hours, only thing i ran into is that her schedule that she uses for work is one day at a time, that's why i created the weekly one, problem is that on my wifes day off she has to put someone else first on them days off but when you do that it caculates the time for them as well, what i'm looking to do is do a lookup of the person and then add the hours and then total.test jpg.xlsx i've attached a file of the sheet i'm using, please advise on best way to go.

[olasa]

I am not sure what you want.

It would help if you,
1. attach the file
2. specify the Input and the Output from the sheet - in preferably, more then one sentence :-)

//Ola

[robert220]

input is the name and hours they work, output is how many hours scheduled and total at end of week. i need something that will find the name and see what hours they work and total at end of week.test.xlsx

[olasa]

This might be a start.
I also made a small test on sheet 2, since I wasn't sure if the Output covered everything.

Hope it helped
Ola

[robert220]

that helped for what i was looking for the totals and everything but, here is were i'm running into problems, this sheet is just a weekly sheet another sheet pulls from it, so the employees can't be in order, like when my wife has wed and sun off someone else has to be in that first spot and then when you add that person it adds there hours aswell. that's what i'm trying to avoid and find away around it.Copy of attachment.xlsx

[olasa]

I hope I understand what you mean: "...when you add that person it adds there hours aswell. that's what i'm trying to avoid"

This formula only counts Shellie's hours, see file sheet 1. The PivotTable does the same thing, it's just more flexible.

HTH
Ola

[robert220]

thank you so much that helps alot.

[olasa]

Happy it worked
Thanks for the feedback
Ola