Forgive me if this is newbie question, but I am creating a excel document that records the information on my pay stubs. I am trying to calculate the dollar amount for the hours worked during that pay period, all the while using a second table for the rate which has all of my pay increases.
Table #1 has the following fields:
Period Beginning || Period Ending || Hours Worked || Total $ ...........
Start Date || End Date || Pay Rate
Essentially I want to figure out the Total $ using table 2, but I want to make sure that it is choosing the right rate for that time period.