Consolidation Hours Computation

[agmoraojr]

Hi all,

A1 - A3:A6 = Displays the lowest Value
B1 - B3:B6 = It should display the highest value in hours(it should be computed right after midnight)
C1 - B1-A1 - the difference between B1 and A1,
C9 - correct result from B1 and A1

Question:
The result will be use instead to display the highest value, am looking here if its after midnight assuming (see AM/morning) it will display the highest/value, opposite of A1. If you have other formula , do share.

Can you please give me the correct formula B1.Edit_Consolidation Hours.xlsx

Thanks