=IF(a140,((a1-40)*payrate*1.5)+(40*payrate),a1*payrate)

"Sandoval" wrote:

I am trying to make a document that is a daily processing cost for my
supervisor. It is actually in week form. I need to times the daily rate by
hours worked for the day. Once the employee has reached 40 hours i need to
times the daily rate by time and a half and then by how many hours worked
overtime and sometimes these are all in one day. So lets say one employee
worked 45 hors after 4 days that 4th day i need to minus the overtime hours
from the regular hours and then times the daily rate. PLEASE someone help me.