Calculate rate of Pay

Is your Rate 1 and Rate 2 coming from a drop down? One thought would be that you use an If Function such as:

=IF(B5="Rate 1","5.00",IF(B5="Rate 2","7.25",""))*A5

A5 being the number of hours and B5 being the rate type. Using 5.00 for Rate 1 and 7.25 for rate 2

The reason I ask if you are using a drop down is b/c the only way this will work accurately, the Rate 1 and Rate 2 will need to be typed exactly the same each time.

Also, if there is no data under the rate column, this would leave that cell blank.

Hi - thanks for your response.

I am getting the rates from a drop down menu - using Vlookup.

What I'm hoping to do is construct a forumula that looks at both the start and end times, and calculates the amount of hours for Rate 1 in one column (Rate 1 $) and calculates the amount of hours for Rate 2 in another column (Rate 2 $).

Thanks