Need Help WIth a Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am Trying to create a Weekly Time schedule for my
business. I have to deduct a half hour from each shift if
more than five hours are worked. i want the calculation
to work in the total column for each employee.

help any one

Thank you
 
=IF(hours>5/24,hours-1/48,hours)

or using cells

=IF(B1-A1>5/24,B1-A1-1/48,B1-A1)
 
Not following where would i enter this this is the
formula for my totals column
=(C3-B3)+(E3-D3)+(G3-F3)+(I3-H3)+(K3-J3)+(M3-L3)+(O3-N3)
 
Hi
assuming that C3 is one of your shift ending times and B3 one of the
starting times you have to use Peo's formula as follows:
=IF(C3-B3>5/24,C3-B3-1/48,C3-B3)+IF(E3-D3>5/24,E3-D3-1/48,E3-D3)+......
+IF(O3-N3>5/24,O3-N3-1/48,O3-N3)

though it may be better to create a sub total for each day/week ??. So
calculate C3-B3 individually and sum up these sub-totals

HTH
Frank
 
Back
Top