MAX/MIN problem with time

hello,

I have the following formula C= day in DD/MM/YYYY and D = Time in HH:MM format and BJ5 is the date

Please Login or Register  to view this content.

which works fine as it finds the max time in a list, however i need to find the min time in the same list, when I change it from MAX to MIN it returns a 00:00,

any clues?

thanks reg

Try instead:

=MIN(IF((D1:D11>0)*(Input!C1:C11=J5),(Input!D1:D11)))

confirmed with CTRL+SHIFT+ENTER

your formula was producing an array trues/falses multiplied by an array of 0's (where cells are blank) and dates... false * 0 = 0 and therefore min=0

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save