View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wouter HM Wouter HM is offline
external usenet poster
 
Posts: 99
Default Intersect for time

Hello Joergen,

If you use the time format for al the cells you mentioned in your
question you could use a formula:

=IF(AND(A1<B1;A1+A2C2);"Intersect 1 +
2";IF(AND(A1<B1;A1+A2B2);"Intersect
1";IF(AND(A1<C1;A1+A2C2);"Intersect 2";"")))

Thuis is a single formula, remove the linebreaks taht might be
inserted by the newsgroup system.


HTH,

Wouter