Work Schedule Timesheet

I have made a work schedule for my local business and have set up a series of formulas that will fill out time cards that I could print out directly onto the paper time cards. The formulas that I have work except that if there are two subsequent entries that later will not return a value and result in an error. If you could take a look at it that would be awesome. To use it you just need to type a name into the name column and a work time into the time column for that day. then in the other sheets( one for each worker ) it will set up the time card. The the error happens on Thursday, when Bob has an entry right after Fred. Then on Bobs sheet it gives me a #N/A. Why?

This is the formula That I am using.

Please Login or Register  to view this content.

Where G$1 is the name of the worker, SundayWorkers is the array of workers for sunday, and SundayHours is the array of hours for sunday.

Thanks you so much for your help. I see one more complication though. What if I have someone working a split shift. I know I would need to split the time boxes into two parts to accommodate for this, but then how do I change the formula to pick up a second entry and also record the time. I re uploaded the new time sheet.

We are only open until 12pm so that is not a problem.

If you look at the updated time sheet I have fixed it up so that it will generate the start, stop, and total hours worked, but for only one entry of that person per day. Is there a way to make it work for multiple entries of the same person on one day. could it just be 'CONCATENATED'ed onto the end of the string?

The Index Function searches from the top of the list to the bottom of the list. Is there a way to inverse this and search from the bottom to the top. I am trying to solve the problem of having a split shift. I would like to get the times start and end times of the person each time his name appears on the list.

E8 is time in, F8 is time out for lunch, G8 is time back in from lunch and H8 is time out at end of day.

I am looking for a formula that would give me total hours worked in I8, can someone please help me out on this?