If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Need Help WIth a Function
=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 |
#3
|
|||
|
|||
Need Help WIth a Function
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 . |
#4
|
|||
|
|||
Need Help WIth a Function
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 . |
Thread Tools | |
Display Modes | |
|
|