Syntax to ignore formula

[Jar888]

Got a bit of a question. Trying to sort out some spreadsheets at work, and I'm somewhat figured most of the formula's out. But the sheets are rolling on from each other.

As seen below, O11 grabs the information from the previous sheet, but because there's a formula in O, the formula in S and U think that cell O is not blank. Is there a workaround to this? Let me know if I need to explain myself more.

00. 54 Workshop Handover Template Rev1.xlsx
	O	P	Q	R	S	T	U
11					#VALUE!		OUT
12
13
NS (1)

Cell Formulas
Range	Formula
O11	O11	=IF('DS (1)'!U11="OUT","18:30","")
S11	S11	=IF((AND(ISBLANK(Q11),O11>0)),TEXT("01/02/1900 6:30"-O11,"h:mm")*24,TEXT((IF(Q11<O11,Q11+1,Q11)-O11),"h:mm")*24)
U11	U11	=IF((AND(ISBLANK(Q11),O11>0)),"OUT","GTG")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
U11,U14,U17,U20,U29,U38,U47,U56,U23,U32,U41,U50,U26,U35,U44,U53	Cell Value	contains "G2G"	text	NO
U11,U14,U17,U20,U29,U38,U47,U56,U23,U32,U41,U50,U26,U35,U44,U53	Cell Value	contains "OUT"	text	NO
U11,U14,U17,U20,U29,U38,U47,U56,U23,U32,U41,U50,U26,U35,U44,U53	Cell Value	contains "Out"	text	NO

 

[Jar888]

Sorry, I figured it out myself. I just needed to re-arrange the formula and the IF functions.

If anyone is interested in the answer;

00. 54 Workshop Handover Template Rev1.xlsx
	O	P	Q	R	S	T	U
11					0		GTG
12
13
DS (2)

Cell Formulas
Range	Formula
O11	O11	=IF('NS (1)'!U11="OUT","6:30","")
S11	S11	=IF((ISBLANK(Q11)),IF(O11="","0",TEXT("18:30"-O11,"h:mm")*24),TEXT(Q11-O11,"h:mm")*24)
U11	U11	=IF(ISBLANK(Q11),IF(O11="","GTG","OUT"),"GTG")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
U11,U14,U17,U20,U23,U26,U29,U32,U35,U38,U41,U44,U47,U50,U53,U56	Cell Value	contains "G2G"	text	NO
U11,U14,U17,U20,U23,U26,U29,U32,U35,U38,U41,U44,U47,U50,U53,U56	Cell Value	contains "OUT"	text	NO
U11,U14,U17,U20,U23,U26,U29,U32,U35,U38,U41,U44,U47,U50,U53,U56	Cell Value	contains "Out"	text	NO