The process I worked out is a little complicated, but it is the most vertsitile. Shifts are probably different on the weekend than the week day so a fixed formula will work out to be very complicated. I think it is easier to do with buildingg a table. Make Sunday Midnight (Saturday night) as hour 0 and then calculate the number of hours from Sunday midnight to the hour of the shift. then