I have two cells that are set for h:mm and the time will switch throughout a
24 hour time period. For some reason ever fix I have tried, the time is still
not calculated properly.

For example:

The first cell is 10:18PM [h:mm] and the second 2:38AM [h:mm] and the
resultant cell has the formula (currently) as:

=C42-E42+(C42<=E42)*2400
I have also tried

=MAX(E42,C42)-MIN(C42:E42)

Both formulas return a value of 19:40. The difference between 10:18PM to
2:38AM the following day shows up as 19:40. Shouldn't the result be like 4
hours and 20 minutes. Or at least that is what I am trying to attempt the
output to be.

Does anyone have the answer?

tia...

Shawn