timesheet formula

[shazeela]

can someone please help me with this..

i have a timesheet that we are trying to use. the problem is the column that says shift diff. if an employee works after 6:30pm for 1and 1/2hr, he is entitled to shift hours. shift hours is between 6:pm and 8am. can you help me add the shift hours automatically in the shift diff column in excel.

As long as he works after 6.30pm but works for at least one and a half hour, he will get the shift.
if he comes to work at 9pm to 12am, then he gets 3hrs shift for those hours too.

[stevekirk]

hi,

if he is late for work / or has half a days holiday and he arrived at 11.30 but works after 6.30 does he get shift diff? or does he have to work say 10hrs before he he entiled toi shift diff? is there dayshift and nightshift if so does the nightshift get shift diff if they work late?

steve

[shazeela]

Thanks for helping me.....
As long as he works after 6.30pm but works for at least one and a half hour, he will get the shift.
if he comes to work at 9pm to 12am, then he gets 3hrs shift for those hours too.
Sharon

[shazeela]

can someone please help me with this..

i have a timesheet that we are trying to use. the problem is the column that says shift diff. if an employee works after 6:30pm for 1and 1/2hr, he is entitled to shift hours. shift hours is between 6:pm and 8am. can you help me add the shift hours automatically in the shift diff column in excel.

As long as he works after 6.30pm but works for at least one and a half hour, he will get the shift.
if he comes to work at 9pm to 12am, then he gets 3hrs shift for those hours too.
some examples are:
if work, 9am to 7:30pm, and have break between 2-3pm, should have 1.5hrs shift and 9.5hrs total
if work, 7:45pm-9:45pm, and have break between 8:30-9pm, total hrs work is 1.5 and shift hrs s/b 1.5hrs
if work 3pm to 12am and have break between 7-8pm, total hrs work is 8 and shift hrs s/b 5hrs