Not including a Cell in a formula

[JDSOuth49]

Summary of my issue:

CELL P15 = USED TO ENTER TRAVEL HOURS (CALCULATED AS STRAIGH TIME ONLY)



CELL Q15 = =IF(WEEKDAY(B4)<=5,IF(S15>8,8,S15),0)+IF(P15<>"",P15,0) **WORKS CORRECTLY-NO ISSUES**



CELL R15 = CALCULATES OVERTIME (REFERENCES CELL S15 à ANY TIME OVER 8 HOURS IS PUT INTO CELL R15 [CELL R15 FORMULA= =IF(WEEKDAY(B5)>5,S15,IF(S15>8,S15-8,0))


I AM NEEDING TO HAVE THE FOLLOWING:

IS A NUMBER IS PLACED INTO CELL P15, THE OVERTIME HOURS ARE NOT CALCULATED {CELL R15} ---ONLY IN THIS INSTANCE, OTHERWISE THE EXISTING FORMULA IS USED---
Something like this: =IF(WEEKDAY(B5)>5,S15,IF(S15>8,S15-8,0), If(P15>0) THEN do not calculate, IF(P15=0 or empty then [=IF(WEEKDAY(B5)>5,S15,IF(S15>8,S15-8,0))] is used.

 

[dreid1011]

Seems to be working for me. Did the formula get changed at all?

Book1
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
6	3/30/2024
7
8
9
10
11
12
13
14				cost codes										travel	regular	ot	total
15							10								0	10	10
16							10							5	5	10	15
Sheet1

Cell Formulas
Range	Formula
Q15:Q16	Q15	=IF(WEEKDAY($C$6,2)<=5,MIN(8,SUM(F15:O15))+P15,0+P15)
R15:R16	R15	=IF(WEEKDAY($C$6,2)<=5,MIN(MAX(SUM(F15:O15)-8,0),SUM(F15:O15)),SUM(F15:O15))
S15:S16	S15	=Q15+R15

 

[JDSOuth49]

dreid1011​

Its working now. I don't know what I was doing.

Again, thank you for you time and effort helping me with this.

 

[dreid1011]

dreid1011​

Its working now. I don't know what I was doing.

Again, thank you for you time and effort helping me with this.

You're welcome.