I believe what I'm asking for requires a MINIFS/MAXIFS however I do not have the functions in the version 2013 I'm using.
What I have is a dump of data with numerous columns where I need to find out when a user starts and finishes their daily maintenance. This is determined by matching their asset in column A, by matching the task they are doing in column H, and it should be between two times, the start in P and the end in Q.
They may do other tasks in between so I need to find when the earliest start time is between the window, and when the last end time is between the window.
The criteria I need to find is:
H:H="*Word*" (anywhere in the text in column H)
I've been able to provide some results based on two criteria using MIN+IF but I'm struggling to make it all work.
Thanks in advance