Hello,

I am trying to calculated overtime hours against projects in a database spreadsheet. I have run into a problem when trying to calculate overtime. The database is a lists of lines of time that contain different information like employee, project, hours, etc. I need to be get it to where overtime starts for a particular employee and associate it with the project where the overtime should be applied to. Below is the order of the headers starting from Column A. I should mentioned that there are many employees in this record. That is my major issue. I need to get it to where the formula is doing some sort of SUMIF on the employee and calculating overtime in Column E on the row where the employee time becomes greater than 40 hours.

Date Project Employee Reg Hours OT1 Hours
11/17/2014 14-0265 B0E6 9
11/17/2014 13-0132 A001 10
11/18/2014 14-0332 A003 10
11/18/2014 13-0132 A001 10
11/18/2014 14-0265 B0E6 11.5
11/19/2014 14-0265 B0E6 11.5
11/19/2014 13-0132 A001 10
11/20/2014 14-0337 A003 7
11/20/2014 14-0288 A003 3
11/20/2014 13-0132 A001 10
11/21/2014 14-0265 B0E6 11.5
11/21/2014 13-0132 A001 8
11/22/2014 13-0132 A001 5
11/22/2014 14-0265 B0E6 10.5
11/23/2014 14-0265 B0E6 10

I would like excel to calculate where OT begins and post those hours against the correct project in the fourth column. Please let me know how this is possible to do?

Thank you,

dkrishman