I am looking to create a worksheet to help estimate labor costs. To do this
I would like to be able to input the "IN TIME", "BREAK TIME" and "OUT TIME".
Also per employee I need catagories for different pay rates. Also after
10hrs. I would need the formula to calculate a over time rate for hours
worked over 10 hours. Additionally hours worked between 12 a.m. and 6 a.m.
would need to be calculated at a different rate as well (double time). Excel
2003

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ECLaborestimate" <(E-Mail Removed)> wrote in message
news:B34B26A4-EED7-46E2-B3ED-(E-Mail Removed)...
|I am looking to create a worksheet to help estimate labor costs. To do this
| I would like to be able to input the "IN TIME", "BREAK TIME" and "OUT TIME".
| Also per employee I need catagories for different pay rates. Also after
| 10hrs. I would need the formula to calculate a over time rate for hours
| worked over 10 hours. Additionally hours worked between 12 a.m. and 6 a.m.
| would need to be calculated at a different rate as well (double time). Excel
| 2003