I need a little boost ...
cmnshiftdur = Round((ecend - lcstart) * 24, 1)
tdiff = cmnshiftdur / 2
cmnshiftdur is the number of hours of overlap of two shifts
tdiff is half that value
I am failing in thought as to how to ...
.Cells(DR, 2) = [color=blue]the value of ecend (end time of shift...