One cell for Regular time + OT.....

[miko_r]

I have an excel sheet that is created and its has regular time and overtime and rate of pay. I only want one cell where I can have total hours (which would include the over time). For example if they worked 9 hours in one day that's 8 plus the one hour. Is there a way to create a formula to just calculate total time plus rate?I have the sheet below. ideally I would like B and C combined *F then in cell G f*1.5 plus the overhead which is *1.8. Does this make sense? I attached a screen shot so you can see the visual

 

[cyrilbrd]

Hi, not sure if you already solved your query, but basically you just need something along =(reg_hrs*rate)+(ot_hrs*rate*coef)