Sophisticated gantt chart

[Arjen Bakker]

Hello forum,

next problem. I need the processed numbers to be substracted from the incoming ones.
I tried to put the figures in this way.

A

B

C

D

E

F

G

H

I

K

L

M

N

O

2

To

Incoming

Outgoing

3

be

Start

End

Perf. per

Start

End

Perf. per

13:00

13:15

13:30

13:45

14:00

14:15

14:30

14:45

4

done

15 mins.

15 mins.

5

40

13:00

14:00

10,0

13:30

14:40

8,6

9

17

26

34

40

In "I5" the formula is:

= IF($C5>K$3;0;MIN(($B5);$H5+I5)) The incoming part. I just need the processed ones to be minussed in one row. Until we get to zero. Thanks for you efforts ! Have a great time ! Arjen