lookup functions errors

[rcocrane99]

Hello everyone, I've been stuck working on some data these last few days and I need to find a way to extract 2 pieces of data per "production day". My company currently operates from about 7 am to 1 am and I need to get a precise "Start" and "Shutdown" time (see row 5 and 6) to then get a "run time". The sample set continues and we will just keep adding as we go so I need something that will kind of just update on another sheet over time.

I've tried, nested xlookups, minifs and maxifs and index match but I couldn't really understand it so if anyone has a creative solution have a wack at it.
Would like to have all of the data here eventually:

 

[Cubist]

Use the empty string "" instead of 0 to "hide".

 

[rcocrane99]

Your equation is: =MINIFS('GaSX Runsheets'!$6:$6,'GaSX Runsheets'!$6:$6,">"&B5)
adding my stuff : '=IF(B6=0,0,IF(INT(MINIFS('GaSX Runsheets'!$6:$6,'GaSX Runsheets'!$6:$6,">"&B6))=A7,MINIFS('GaSX Runsheets'!$6:$6,'GaSX Runsheets'!$6:$6,">"&B6),0))
but then change it to: '=IF(B6="",0,IF(INT(MINIFS('GaSX Runsheets'!$6:$6,'GaSX Runsheets'!$6:$6,">"&B6))=A7,MINIFS('GaSX Runsheets'!$6:$6,'GaSX Runsheets'!$6:$6,">"&B6),0))

 

[Cubist]

Other way around.

=IF(B6=0,"",IF(INT(MINIFS('GaSX Runsheets'!$6:$6,'GaSX Runsheets'!$6:$6,">"&B6))=A7,MINIFS('GaSX Runsheets'!$6:$6,'GaSX Runsheets'!$6:$6,">"&B6),0))

This will give your run-time column an error because it's trying to subtract a string. You also do =IFERROR(....,"").