I am trying to combine this formula
=IFERROR(1/1*(IF(D32=1,'Hours Of Service'!E4,IF(D32=2,'Hours Of Service'!N4,"")*1)),"")
With this Formula
=INDEX(E11:E18454,MATCH(TRUE,(D10:D18454>='Pre Trip Bid Summary'!I24),0))*60
This is one of the several ways I have tried.
I have gotten two...