Hi

I'm new to this forum but not Excel but there's a problem I seem unable to solve. I have put together a small spreadsheet for overtime payments. Depending on the person's pay rate and the time of day, the hourly rate for overtime varies.

I want to use the value in column A and the time in column D to then lookup into the table of rates and put that back in column E. I hope this picture clarifies what I'm after

\1


Thanks in advance of any replies
Alun