Payroll calculations for real time

[orlcgm]

I need a formula so that I can calculate the true hours including overtinme
at time and a half... how do I separate the overtime them add the regular
hours and calculate the hours of overtime by .5 and add it to the regular
hours??

 

[Glenn]

I need a formula so that I can calculate the true hours including overtinme
at time and a half... how do I separate the overtime them add the regular
hours and calculate the hours of overtime by .5 and add it to the regular
hours??

How do you define "overtime"? Greater than 8 hours in one day, greater than 40
hours in a week, some combination of both?

 

[Eduardo]

Hi
take a look at Chip web he has what you need

http://www.cpearson.com/excel/overtime.htm