Forum Discussion
Help with formulas
A photo is of very limited use. Your verbal description actually tells more. But the photo does raise questions in my mind about the whole design. SO, may I suggest -- since at this point the whole thing looks blank anyway -- that you create a version without real employee names (use Disney characters or favorite movie stars) and post the actual dummy spreadsheet. If you can't do it here, post it on OneDrive or GoogleDrive, and post a link here that grants access.
I should add, although I'm retired now I was the director of a corporate database system for employee data, including aspects such as time and pay, so I'm coming at this from a background of experience with exactly this kind of data. So I enthusiastically agree and support your desire to make the timesheet more efficient; I would suggest just from the glimpse your photo provides that a more basic redesign might be in order. But it's hard to tell without seeing it more closely, seeing a bit more how it works, what the input and output is, etc.