Need Help WIth a Function

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(hours5/24,hours-1/48,hours)

or using cells

=IF(B1-A15/24,B1-A1-1/48,B1-A1)

--

Regards,

Peo Sjoblom

wrote in message
...
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

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)
-----Original Message-----
=IF(hours5/24,hours-1/48,hours)

or using cells

=IF(B1-A15/24,B1-A1-1/48,B1-A1)

--

Regards,

Peo Sjoblom

wrote in message
...
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


.

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-B35/24,C3-B3-1/48,C3-B3)+IF(E3-D35/24,E3-D3-1/48,E3-D3)+......
+IF(O3-N35/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


wrote:
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)
-----Original Message-----
=IF(hours5/24,hours-1/48,hours)

or using cells

=IF(B1-A15/24,B1-A1-1/48,B1-A1)

--

Regards,

Peo Sjoblom

wrote in message
...
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


.