S
Sonic
What I need is to have a formula that will find out if someone has worked a
shift.
My shifts run 5 am to 11am, 11am to 1:30pm, 1:30pm to 5:00.
Col A = employee's name
Col B = Clock in
Col C = Clock out
Col D = Total hours
Col E = Rate of Pay
Col F = Total of D*E
How if Sue works for 7$ an hour and works 9am to 4:30pm I need to know how
may hours she worked for the diff shifts she worked. In another col i need to
know what the total of Col F is for each shift.
Any help would be Great and Thanks
shift.
My shifts run 5 am to 11am, 11am to 1:30pm, 1:30pm to 5:00.
Col A = employee's name
Col B = Clock in
Col C = Clock out
Col D = Total hours
Col E = Rate of Pay
Col F = Total of D*E
How if Sue works for 7$ an hour and works 9am to 4:30pm I need to know how
may hours she worked for the diff shifts she worked. In another col i need to
know what the total of Col F is for each shift.
Any help would be Great and Thanks