I have a workbook that tracks my employees time.
I need to be able to figure out how many hours to pay at regular rate, vacation rate, holiday rate and overtime. Vacation/Holiday time is not counted towards overtime.
Example. Col A = total number hours worked
Col B = total number regular (straight) time
Col C = total number vacation hours
Col D = total number holiday hours
Col E = total number overtime hours
I know there are a variety of ways to make the initial entry in Col A (include or not include vacation/holiday hours), how I do it is not as relevant as getting it done!
I welcome any assistance on this!