Hey folks,

I've been trying to figure this out for quite some time now. I have a list of technicians with different shifts ranging from day to overnight (start and end on different days). I am trying get the time difference from the time stamp to the start of the techs individual shift. I have no problem doing that calculation but only having it calculate if the technician is scheduled is what I am having an issue with. There isn't a set shift type so everyone doesn't work Monday - Friday. They also can work from 10:00pm Monday night to 7:30am Tuesday morning.

I attached a spreadsheet and highlighted the two columns that I am trying to calculate.


Any help would be great!

https://dl.dropboxusercontent.com/u/...t%20Times.xlsx