If statement using time format in Excel
<p>I'm trying to set up something in excel where in cell F4 is a calculated time, in the format of something like this: 9:30:00. (Hours:Minutes:Seconds)
Cell e8 is a static number that never changes, unless you manually change the cell lets say it's set as 10.</p>

<p>I am trying to set up a cell that looks at call f4, checks if its under 9:00:00 and if it is then times cell e8 by cell f4, if it's over 9 simply times cell e8 by a static number of 8.</p>

<p>my current code is t working,</p>

<p>=IF(f4>9:00, e8*9, e8*f4)</p>