Earliest time ignoring 00:00 values

[robulyatt86]

Hi Everyone,

I am having a minor melt down with a formula or lack of. I have a rather large table which has a whole load of times in.

I have added a column to the end and i want it to show the earliest time but ignore 00:00.

For some reason every example i have found online does not work. And i am unsure how i can modify the =min formula.

Any help much appreciated.

Rob

 

[JoeMo]

Try this array formula confirmed with ctrl+shift+enter:

=MIN(IF(A1:A1000<>0,A1:A1000))

Change range to suit.

 

[robulyatt86]

Hi Joe,

Thanks for your reply, I have just given that a go and it returns a #VALUE !

Could that be because the times are being looked up from another sheet?

Rob

 

[robulyatt86]

Apologies ignore that my problem has been solved, i pressed the wrong key.

Thanks Joe...!

 

[JoeMo]

Apologies ignore that my problem has been solved, i pressed the wrong key.

Thanks Joe...!

You are welcome - thanks for the reply.