Differing pay rates for multiple employees in a job costing spreadsheet?

Sorry, new on the block so hopefully not breaking any rules already (!)

I'm a cost administrator for a construction company. I keep costing spreadsheets for each building project with tabs for employee costs, professional fees, suppliers etc

The employee costs are in a table with the date (week ending) heading the columns and the employees listed in rows, their weekly hours are inserted into that table.

Now however I've got a situation where some employees pay rates are staying the same, some are going up and some are going down, this is all happening on different dates for different employees. So this simplified table doesn't seem fit for purpose anymore.

I am racking my brains on how to do this simply but I'm struggling. Has anyone had to do this before? I imagine it's common but might be wrong!

Any help would be greatly appreciated!

Thank you for that.

I think I've uploaded a worksheet - as I am using them now - but it's not very clear!

I've added to the employee tab when the pay rates change into cell notes and what they are changing to is noted at the end of the table for the two 'example' employees. Anything needs clarifying just let me know!

Thanks again for any help!

Thanks for getting back to me.

I haven't been given the new pay rate etc yet so this is just an example of what I can expect.

Like I said in previous post, I have outline the dates the pay rates change in the cell notes in the employee tab (I'll give you the cells the notes are in: AC6 and BG6 for employee one and BU7 for employee 2).

Not actually sure where that formula in Summary tab D6 came from. At this point how pay rates etc are calculated isn't really where I'm needing help - its more in finding a way of setting out costs for weekly hours while pay rates are constantly changing for each employee at different times!

For example, at the moment this test sheet is only showing the total cost of hours worked for two employees at one pay rate each. Chances are as time goes on, there is going to be multiple pay rates for everyone.

Hope that makes sense!

Thank you for this. It is along the lines of what I was thinking, so it's good to know I'm on the right track (even if I have very little experience in all this!)

Going to give that a go, I think I'll only really know what's working when I try it out in practice.