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