Nested IF Statement

[godzilla65]

Hi All,

I am in the final stages of building a formula based, 24hour (15 min interval) Gantt chart, within my workbook

I am struggling with one formula, as follows: I am entering this formula into Cell N5

If C5=Blank, then E5 Otherwise C5, If E5=Blank, then G5 Otherwise E5, If G5=Blank, then I5 Otherwise I5
If I5=Blank, then K5 Otherwise I5,If K5=Blank, Then Blank

Eg: of Data
C5 = 04:15
E5 = Blank
G5 = 12:00
I5 = Blank
K5 = 16:15
Result would be: 04:15

Eg: of Data
C5 = Blank
E5 = Blank
G5 = 12:00
I5 = Blank
K5 = 16:15
Result would be: 12:00

Eg: of Data
C5 = Blank
E5 = Blank
G5 = Blank
I5 = Blank
K5 = 16:15
Result would be: 16:15

Hoping that makes Sense ? and hope you can assist

Cheers Eric, Brisbane, Australia

 

[AhoyNC]

Try:

I noticed that the times increase in the cells in your example. If this is true of your data you may be able to use the MIN function as in cell N7 of the example below.

 

[AhoyNC]

Try:

I noticed that your times increase as you go across if this is true of all your data you may be able to use the MIN function.
Both If and Min shown in example below.

Excel Workbook
	C	D	E	F	G	H	I	J	K	L	M	N
5	4:15				12:00				16:15			4:15
6
7												4:15
Sheet