=IF A1=1 then B1=x and B2=x also =IF A1=2 then B1=x and B2=x and B3=x and B4=x

podko · #1 12-20-2011, 01:14 PM

Quote:

Originally Posted by Pecoflyer

Hi

is this an XL problem?
Could you please provide some more explanation, perhaps post a sample sheet?

It looks almost like calendar in outlook

A B C
1 CET Availability Duration in hrs
2 08:00 Busy 02:00
3 08:30 Busy
4 09:00 Busy
5 09:30 Busy
6 10:00
7 10:30
8 11:00
9 11:30
10 12:00
11 12:30 Busy 01:00
12 13:00 Busy
13 13:30
14 14:00
15 14:30
16 15:00
17 15:30
18 16:00 Busy 00:30
19 16:30
20 17:00

21 17:30
22 18:00
23 18:30
24 19:00

sorry if I can't describe any better....
thx