boccuz
02-03-2021, 02:06 PM
Hello,
I am trying to calculate if a the time of a call (Column "E") falls between the hours of the day shift or the night shift. If the time falls between the hours of the day shift, I would like to place the number 1 in column "H" or in column "K" if it falls within the hours of the night shift. Our night shift starts at 23:00 hours the previous day and ends at 06:00 hours. For clarification, If I am scheduled to work the night shift on Wednesday, I would report for duty on Tuesday evening at 23:00hrs and work until 06:00 hours on Wednesday. The Wednesday day shift would be 06:00 to 23:00 hours. I tried calculating the time using columns "F". "G", "I", and "J", but i am not sure I really need these columns. looking for the simplest way possible. Thank you for your help.
I am trying to calculate if a the time of a call (Column "E") falls between the hours of the day shift or the night shift. If the time falls between the hours of the day shift, I would like to place the number 1 in column "H" or in column "K" if it falls within the hours of the night shift. Our night shift starts at 23:00 hours the previous day and ends at 06:00 hours. For clarification, If I am scheduled to work the night shift on Wednesday, I would report for duty on Tuesday evening at 23:00hrs and work until 06:00 hours on Wednesday. The Wednesday day shift would be 06:00 to 23:00 hours. I tried calculating the time using columns "F". "G", "I", and "J", but i am not sure I really need these columns. looking for the simplest way possible. Thank you for your help.