Return earlies and latest time

Hello,

I'm trying to make a an excel time sheet (see attached). The first sheet is what a manager would use to put in hours and the second sheet is a summary of the first sheet for employees to use. The problem that I'm having is that in the below formula when time crosses midnight the 'small' and 'large' functions don't work. Any ideas?

=IFERROR(TEXT(INDEX(Sheet1!$B$2:$R$2,SMALL(IF(Sheet1!$B4:$R4="x",COLUMN(Sheet1!$B:$R)),1)-1),"HAM/PM")&" to "&TEXT(INDEX(Sheet1!$B$2:$R$2,LARGE(IF(Sheet1!$B4:$R4="x",COLUMN(Sheet1!$B:$R)),1)),"HAM/PM"),"")