This solution will solve your regular day overtime but overtime gets more
complicated when it comes to holidays. You won't be able to calculate
overtime this way, unless there is a specific code that will tell you if the
hours are regular hours or holiday hours. I have made a similar overtime
calculation and it was more complicated due to union agreement and holiday
pays.
CindyHoskey wrote:
Assuming your cell with the daily hours is in A1, put this in B1 (for your
overtime hours):
=If(A18,A1-8,0)
Then put this in C1 (for your regular, non-overtime hours):
=If(A1<=8,A1,8)
(I worked for a temp agency for 8 years)
- Cindy
I am creating a spreadsheet in an early version of excel (02-03), for a
company who has several different employees. This company calculates
[quoted text clipped - 8 lines]
make the proper multiplication, but I just don't know how to filter out
overtime. Thanks so much!
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1