Need Help with a Formula

[JRosado]

Hi Everyone -

This is my first post to this forum. I am not a very advanced Excel user. I need help with a formula for a Time Sheet. We are a construction company and need to track each employee's time for various projects, and various phase codes within each project. Employees are only eligible for overtime if they work more than 40 hours per week. We also pay shift differential for night work. I would like to add a formula to the attached time sheet that would automatically calculate overtime hours only if the hours worked are over 40 in a week. In other words, an employee may work 10 hours in one day, but if they don't exceed 40 in the week, the overtime cell would remain blank. Also, if they do exceed 40 hours in a workweek, I would like the overtime hours to show up in the cells of the days where the hours exceeded 8 in a day. Basically, if we do pay overtime, we charge it to the job which caused the employee to go into overtime so we need to indicate what day of the week that is. I would greatly appreciate any help in creating a formula that would do this.

One more thing, I have a drop down list with L&I risk classification codes the employee may choose from when completing their time sheet, but I don't know how to extend the width of the column so the entire description displays?

Thanks!

[shg]

Welcome to the forum, JRosado.

Please take a few minutes to read the forum rules (link in menu bar), and then amend your thread title accordingly.

Thanks.

[cbascle]

I have the same problem as JRosado, but could not find where it was re-posted with an amended thread title. Is there another thread that would help with this question?

[vlady]

@ cbascle.
You can create a thread regarding your problem. Since you cannot ask question in anothers thread.


No further response will be given to this thread until OP complies in the request of the senior member. Post#2
Thank you for your cooperation.