Thread: how to get "day/night" from a cell of time/hour
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kbee kbee is offline
external usenet poster
  
Posts: 20
Default how to get "day/night" from a cell of time/hour
cell a1=1/1/08 08:00:00 AM, cell a2= 1/1/08 22:00:00 PM
cell b1 or b2= day/night
what should be the syntax?
thanks to anyone who can help with this.

Reply With QuoteReply With Quote