excel calculate hours from range of dates with end date

dear excel experts

good evening to all

CALCULATE HOURS START WITH OPEN DATE FROM (LARGEST DATE) BETWEEN(SEASON 1,2,3)
OR SEASON-1
OR SEASON-2
OR SEASON-3
WITH END DATE.

END DATE SHOULD BE GREATER THAN CALCULATION DATE IF ITS NOT GREATER THAN CALCULATE DATE RESULT "END DATE LESSER THAN CALCULATION DATE"

pls find the attachment