Determine if night shift by start & end time

[morand.84]

Hi all

I have an excel file containing start and end time for employees
i need to figure out if an employee's salary is calculated by night shift or day shift rate.
a shift is calculated as a night shift if the employee worked two hour or more between the hours of 22:00 (10:00 PM) to 06:00 (6:00 AM).

i can't figure out the way to determine the type of shift.

Example:

start time end time day / night
--------------------------------------------
8:00 20:00 day
20:00 8:00 night
4:00 17:00 night
15:00 23:00 day
18:00 0:00 night

any ideas would be welcome

thanks, moran

 

[bill k]

Hi all



I have an excel file containing start and end time for employees

i need to figure out if an employee's salary is calculated by night shift or day shift rate.

a shift is calculated as a night shift if the employee worked two hour or more between the hours of 22:00 (10:00 PM) to 06:00 (6:00 AM).



i can't figure out the way to determine the type of shift.



Example:



start time end time day / night

--------------------------------------------

8:00 20:00 day

20:00 8:00 night

4:00 17:00 night

15:00 23:00 day

18:00 0:00 night



any ideas would be welcome



thanks, moran

 

[bill k]

c13 is start time
d13 is finish time

enter in e13 =IF(AND(C13>0.25,D13>C13),"d","n")
seems to work for the combinations in your example.
You may have to try out some more practical lists.

Regards
Bill Kuunders