Thread: [Solved] How to categorize time into Day/Night?
View Single Post
 
Old 12-22-2017, 01:36 PM
ProudLiberal's Avatar
ProudLiberal ProudLiberal is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Jun 2017
Location: suburban Chicago
Posts: 28
ProudLiberal is on a distinguished road
Default
=if(and(a1>(6/24),a1<(19/24)),"day","night")
Reply With Quote