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

E

ECLaborestimate

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 calcalate hours above 7am and >19:00am leaving 12 hrs 2
help cumulative hrs 1
IF statements help 1
Determine if night shift by start & end time 2
Case Statements 0
Vlookup 0
Calculate OT/TIL hours when 1st 2 hrs are double time, rest are 1: 2
~~~ Distinguishing Normal; X1.5 and X2 Hours throughout the week by what day and time they are worke 0

Top