Quote:
Originally Posted by xor
Like this?
|
Sort of. I did think about having a column for hourly rate and formatting the wage column to calculate hours*hourly rate, however I am also having columns for things like overtime, sick, and being late. I wanted to keep the table as streamlined as possible, minimize the amount of columns, if that makes sense? I also thought I could have their wage rate on a separate sheet and have the formula for wage reference the info on that sheet. Ideally though, I would like to be able to type in the name of the employee and that name is formatted to calculate their hourly rate by referencing the hours listed in a given row. I know you can name a cell or a group of cells, but couldn't figure out how to attribute a formula to a name that you type into a cell. I don't know if this is possible but it would make things so much easier if it were!!