No, this doesn't make sense. The 2nd entry in your expected result set states Late 12/11/2012, however, in your first dataset it's morning on 12/11/2017. Can you provide a full expected result set, as "and so on" doesn't give us enough to represent values other than Late.
Thanks.
OOps my bad -
name Shift From To
Graham Late 22/10/2017 05/11/2017
Graham Morning 12/11/2017 12/11/2017
Graham Afternoon 19/11/2017 03/12/2017
Tracy ...... (and so on)
Sorry about that