View Single Post
 
Old 02-18-2017, 08:13 AM
jllee14 jllee14 is offline Windows 10 Office 2013
Novice
 
Join Date: Feb 2017
Posts: 8
jllee14 is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
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!!
Reply With Quote