How do I make a formula determine a.m. hrs and p.m. hrs in excel?

G

Guest

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
 
N

Niek Otten

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i subtract a half hour from a time when >8 hrs. 3
Help in Complex excel formula! 0
IF statements help 1
Calculate OT/TIL hours when 1st 2 hrs are double time, rest are 1: 2
how to calculate time in a payroll worksheet 9
WKLY HRS/WKLY PAY = Rate per HR 2
How to make a Formula containing times. 7
multiply criteria in a range using sumifs 1

Top