I am new to any type of advanced Excel formulas, and really need some help creating a payroll worksheet. The idea behind the worksheet, is to simply enter in employee start and stop time. Then have Excel make all the calculations telling me what to input into Quick Books. Nice simply and easy.
Here's the problem:
We have different type's of shifts: Splits, Up For Grabs, and Regular. I need a way for Excel to distinguish between the shifts. This way i can get a total for the number of hours, of each type of shift, because they have pay differentials.
I also need a way for Excel to mark any hours over 40 as overtime, in addition to identifying holidays.
I know this is a lot to ask, but i am confident with some proper guidance it can be done.
I appreciate any feedback.
Bookmarks