Hi there. I have another formula I would like help with (please) using the IF function. Well i think its the IF function.....
Please see attachment.
The total number of hours worked per day in cell C17. In this case its 16 hours.
- The first 8 hours are paid at Normal Rate,
- 8.01 to 9.99 hours are paid at 1.5x normal rate and....
- 10 hours + are paid at double time.
I would like to in cell C19 C19 and C20 have number of hours automatically put into these cells, as with each day of the week.
I hope this is enough detail for you.
Thanking you in advance.....
monique
See attachment below....I forgot to attach it....sorry
Bookmarks