Thread: IS A TIME BETWEEN TWO TIMES EG 12:00 & 8:00
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default IS A TIME BETWEEN TWO TIMES EG 12:00 & 8:00
=IF(AND(A1=--"00:00",A1<--"08:00"),"Early",IF(AND(A1=--"08:00",A1<--"17:00"),"Day","Late"))

--
__________________________________
HTH

Bob

"Shirley4589" wrote in message
...
Can you calculate whether a time is between two other times to show early,
day or late shifts for example?


Reply With QuoteReply With Quote