Quote pay rates?


Hey guys,

I’m hoping someone out there can help with this. Sorry if this is not the best place to post this.

I am trying to build a quote calculator to estimate the cost of a shift for a few employees.

The difficulty comes from the fact that the pay rates are different depending on the time of the day and not depending on the employee (e.g. between 9am and 2pm I pay $1/hour, from 2pm to 5pm I pay $1.5/hour and then from 5pm to 9pm I pay $2/hour). I’d really like to build a table/form where I can get the estimated cost when I request a shift (e.g. I want to see how much a shift will cost this Friday from 10am to 4pm).

Does anyone have any clue how to achieve this?

Thanks a lot.