79705198

Date: 2025-07-17 17:29:28
Score: 1
Natty:
Report link

Try =IF(N2="","",IF(OR(N2<TIME(8,0,0),N2>=TIME(19,0,0)),"Out of Hours","In Hours"))

This conditional checks if time is before 08:00 (N2<TIME(8,0,0)) or after 19:00 (N2>=TIME(19,0,0)). If either is true, then it's Out of Hours. Otherwise, its In Hours

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: vmHernandes