View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ECLaborestimate ECLaborestimate is offline
external usenet poster
 
Posts: 1
Default How do I make a formula determine a.m. hrs and p.m. hrs in 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