M
Myrna
Time Sheet Reads as followed:
A B C D E
4 Mark 8.00 4
5 Joe 12.00 0
6 Jim 5.00 5
7 Jay 6.00 0
8 Julie 7.00 5
9 Zoe 6.00 0
10 Al 5.00 6
11 Ken 5.00 0
A= Employee's B= Hourly Rate C,D,E,etc. = Weekday hours
How do I create a formula to figure The Labor Rate Daily for column C?
I have 8 employees total, but only 4 employees worked that day. I need a
formula to add the total labor rate for Column C for the 4 employees.
The answer will be $25.00
Thank you,
Myrna
A B C D E
4 Mark 8.00 4
5 Joe 12.00 0
6 Jim 5.00 5
7 Jay 6.00 0
8 Julie 7.00 5
9 Zoe 6.00 0
10 Al 5.00 6
11 Ken 5.00 0
A= Employee's B= Hourly Rate C,D,E,etc. = Weekday hours
How do I create a formula to figure The Labor Rate Daily for column C?
I have 8 employees total, but only 4 employees worked that day. I need a
formula to add the total labor rate for Column C for the 4 employees.
The answer will be $25.00
Thank you,
Myrna