Determine if night shift by start & end time


M

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
 
Ad

Advertisements

B

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
 
Ad

Advertisements

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top