View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jorgen Bondesen Jorgen Bondesen is offline
external usenet poster
 
Posts: 11
Default Intersect for time

Hi Wouter

Thanks for reply.

--
Best regards
Jorgen Bondesen


"Wouter HM" skrev i en meddelelse
...
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