min/maxifs

[rcocrane99]

Hi everyone, I'm in the process of making an excel sheet that will be used to log data for a chemical plant and I need to provide live updated statistics that we can use to monitor for efficiency purposes.

Currently I am looking to track the amount of "run time" we have each day by looking at a "start up time" and "shutdown time". I currently have a minifs for the start and maxifs for the shutdown where the criteria is the date. My issue is sometimes we shut down past midnight so the formula reads that value as a the min for the next day.

=MINIFS('GaSX Runsheets'!$6:$6,'GaSX Runsheets'!$7:$7,Stats!J19) - this is what im currently using where on a separate sheet I have my dates for the criteria.

open to any creative solutions as well

thanks

 

[Cubist]

Add another condition on row 5 = "Start". Similarly for "Shutdown".

 

[rcocrane99]

Add another condition on row 5 = "Start". Similarly for "Shutdown".

I've tried but for some reason it keeps giving me the spill error, I've read that that means there are multiple answers to my formula but I can't figure out where

 

[Cubist]

I've tried but for some reason it keeps giving me the spill error, I've read that that means there are multiple answers to my formula but I can't figure out where

There can only be 1 min or 1 max.