Thread: USING THE NESTED IF FUNCTION TO SEE IF A TIME DATE VALUE IS T OR F
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gunnerpatt gunnerpatt is offline
external usenet poster
  
Posts: 1
Default USING THE NESTED IF FUNCTION TO SEE IF A TIME DATE VALUE IS T OR F
If time is between 7am and 11am = morning
If time is between 12pm and 5 pm = afternoon
If time is 5pm and < 7pm = Evening
If time is between 7pm and 11pm = Night
If time is between 12am and 6am = midnite

I am having trouble getting the time component of the "DATE TIME" 6/02/03
12:21 AM - to be evaluated by the formula.
Any help would be greatly appreciated

Thanks
Reply With QuoteReply With Quote