I need a little help combining these two functions please. "=IF(B2="Off", and combine with "=HOUR(A3)"
This is for an Overtime program. The formula will be entered in cell C3. The time in A3 may look like 9:45. I just want "9" to appear in cell C3 if B2 has "Off" in it. Thank you in advance.