HELP!! Formula with different conditions
Try these...
A2 = total hours worked
B2 = Reg hours
=MIN(7.5,A2)
C2 = Hours 7.5 but <=11
=IF(A211,3.5,MAX(0,A2-7.5))
D2 = Hours 11
=MAX(0,A2-11)
--
Biff
Microsoft Excel MVP
"Teri" wrote in message
...
Hi there. I'm hoping someone can help me. I'm pulling my hair out trying
to
figure out how I can take a certain number of hours (for OT banking
purposes)
and calculating anything over 7.5 hours, up to 11 hours in one column -
and
anything over 11 hours in a separate column.
For example: An employee worked 15 hours in a day. In the first column
the
formula would provide the number 3.5 (as 7.5 plus 3.5 is 11 hours for the
day) and the second column would provide the number 4 (as this is the
number
of hours over the 11 hours).
Any help that anyone could provide would be GREATLY appreciated!
Thanks so much!!
Teri
|