Consolidation Hours Computation

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

Originally Posted by oEx

Why is A9=19:26:00?

Hi oEx - A9 is the result as the lowest value from A3:A6 as a result below, I used =MIN as the formula.

Isn't MIN(A3:A6) = 17:21:36?

<-- Yes you are correct, I mislook.

Can you reformulate my excel.

A1 - A3:A6 = Displays the lowest Value

This is 17:21:36.

But why do you have in your example in A9 19:26:00?
I don't understand the logic you are looking for.

Originally Posted by HansDouwe

This is 17:21:36.

But why do you have in your example in A9 19:26:00?
I don't understand the logic you are looking for.

- Disregard the A9, Excel sheet reposted.

Cell B1 -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.

Attachment 849524

These formulas returns the expected results:

Please try in A8:

Formula:

Please Login or Register  to view this content.

and in B8:

Formula:

Please Login or Register  to view this content.

and in C8:

Formula:

Please Login or Register  to view this content.

and format A8 and C8: hh:mm:ss and format B8: h:mm:ss

You are Welcome! Thanks for the feedback and rep . Glad to have helped.