Thread: [Solved] How to categorize time into Day/Night?
View Single Post
 
Old 12-23-2017, 12:56 PM
Logit Logit is offline Windows 10 Office 2007
Expert
  
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
.
Assuming your time data begins in F2 :

Code:
=IF(AND(F2>=TIMEVALUE("6:00:00"))*(F2<=TIMEVALUE("19:00:00")),"Day","Night")
Reply With Quote