View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
jmj713 jmj713 is offline
external usenet poster
 
Posts: 57
Default Automatic Data Entry

How about being more specific with your question.

Surely. What I have is either "Shift 1" or "Shift 2" in Column D. I need a
formula that will automatically enter into Column I either "2:00" or "7:00"
respectively.