Just put all the data/variables into separate cells, and then in the total cell, write your equation. If the variables are all in one column, it should look something like:
Where A1 thru A9 are the hours worked, and A10 is the rate. (And, for example, if this took 10 rows, this equation would be placed in A11).
If you have one column like this for each person, then you would do the same in columns B, C, D, and so on, depending on how many people there are to track.
The grand total would be in its own cell, anywhere you like, and would be something such as:
Or you could write it as:
The trick to excel is inputting all your data first, and then adding equations to perform operations on those data.