title: MinIfs syntax with conditional time/date
body: <p>I'm trying to use the <code>MinIfs</code> method of the <code>WorksheetFunction</code> object to determine a conditional minimum.
  Adding another condition makes my code fail, resulting in 0, which suggests that the last condition is not satisfied in the used range. But in fact it is.</p>
  <p>What I need help with is the correct syntax of the last condition.</p>
  <p>What works:</p>
  <pre><code>WorksheetFunction.MinIfs(wsSource.Columns(34), wsSource.Columns(36), False, wsSource.Columns(14), False, wsSource.Columns(3), wsL.Cells(j, 13).Value)
  </code></pre>
  <p>What doesn't:</p>
  <pre><code>WorksheetFunction.MinIfs(wsSource.Columns(34), wsSource.Columns(36), False, wsSource.Columns(14), False, wsSource.Columns(3), wsL.Cells(j, 13).Value, wsSource.Columns(34), &quot;&quot;&quot;&gt;&quot;&quot;&amp;&quot; &amp; startTime)
  </code></pre>
  <p>The variable <code>startTime</code> is defined as a date, and contains date and time information. Column 34 contains date and time information in custom format that looks like this: <code>2021.01.04  22:20:07</code>.</p>
  <p>What the code is trying to do is to find the earliest time and date that fits the other criteria after a certain time of that specific day (stored in <code>startTime</code>).</p>
  <p>Changing format, however, shouldn't matter, and in fact it doesn't: I changed the source's format to number and it hadn't worked either. I tried to replace <code>startTime</code> with <code>CDbl(startTime)</code> as well.</p>