subtracting time for conditional formatting

[jbrown021286]

Dailey Ros.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	Promise Time	Job	Time	Tag	Tech	track	Search	Ramy		Josh		Aldo		Tre		Jeffrey		Brayan		Angle		XXX		XXX		7:58:34 AM
2	9:45 AM	recall af cf	1	1138	me			Weeks Hours		Weeks Hours		Weeks Hours		Weeks Hours		Weeks Hours		Weeks Hours		Weeks Hours		Weeks Hours		Weeks Hours
3	10:15 AM	ocr, bs	1	9560	j
4	2:00 PM	recall af cf	1.3	4766				0		0		0		0		0		0		0		0		0
5	5:00 PM	diag	1	7851				RO. Count		RO. Count		RO. Count		RO. Count		RO. Count		RO. Count		RO. Count		RO. Count		RO. Count
6
7								0		1		0		0		1		0		0		0		0
8								Total Hours		Total Hours		Total Hours		Total Hours		Total Hours		Total Hours		Total Hours		Total Hours		Total Hours
9
10								0		1		0		0		1		0		0		0		0
11
12
13
Dash Board

Cell Formulas
Range	Formula
H1	H1	='data grouping'!$F$2
J1	J1	='data grouping'!$I$2
L1	L1	='data grouping'!$L$2
N1	N1	='data grouping'!$O$2
P1	P1	='data grouping'!$R$2
R1	R1	='data grouping'!$U$2
T1	T1	='data grouping'!$X$2
V1	V1	='data grouping'!$AA$2
X1	X1	='data grouping'!$AD$2
Z1	Z1	=NOW()
H4	H4	='data grouping'!$F$5
J4	J4	='data grouping'!$I$5
L4	L4	='data grouping'!$L$5
N4	N4	='data grouping'!$O$5
P4	P4	='data grouping'!$R$5
R4	R4	='data grouping'!$U$5
T4	T4	='data grouping'!$X$5
V4	V4	='data grouping'!$AA$5
X4	X4	='data grouping'!$AD$5
H7	H7	='data grouping'!$G$5
J7	J7	='data grouping'!$J$5
L7	L7	='data grouping'!$M$5
N7	N7	='data grouping'!$P$5
P7	P7	='data grouping'!$S$5
R7	R7	='data grouping'!$V$5
T7	T7	='data grouping'!$Y$5
V7	V7	='data grouping'!$AB$5
X7	X7	='data grouping'!$AE$5
H10	H10	='data grouping'!$F$7
J10	J10	='data grouping'!$I$7
L10	L10	='data grouping'!$L$7
N10	N10	='data grouping'!$O$7
P10	P10	='data grouping'!$R$7
R10	R10	='data grouping'!$U$7
T10	T10	='data grouping'!$X$7
V10	V10	='data grouping'!$AA$7
X10	X10	='data grouping'!$AD$7

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G2,D2:D86	Cell Value	duplicates	text	NO
E2:F2,E3:G13,E14:F24,G17:G24,E25:G29,E30:F39,G32:G39,E40:G44,E45:F54,G47:G54,E55:G59,E60:F69,G62:G69,E70:G74,E75:F84,G77:G84,E85:G86	Expression	=E2<>""	text	NO
D2:D86	Expression	=E2<>""	text	NO
D2:D86	Cell Value	duplicates	text	NO
C2:C86	Expression	=E2<>""	text	NO
B2:B86	Expression	=E2<>""	text	NO
A2:A86	Expression	=E2<>""	text	NO
H10:X10	Other Type	Color scale		NO
H7:X7	Other Type	Color scale		NO

i am trying to highlight rows in a table that may miss a promised-out time. Column a is the time it needs to be done column c is the amount of time it takes to do it in .1-hour increments. is there a formula i can enter into column f that subtracts the time in C from A so i can have a conditional formatting set to highlight it when it reaches the value of Z1

 

[Peter_SSs]

Is this what you mean?

jbrown021286.xlsm
	A	B	C	D	E	F
1	Promise Time	Job	Time	Tag	Tech	track
2	9:45 AM	recall af cf	1	1138	me	8:45 AM
3	10:15 AM	ocr, bs	1	9560	j	9:15 AM
4	2:00 PM	recall af cf	1.3	4766		12:42 PM
5	5:00 PM	diag	1	7851		4:00 PM
Sheet1

Cell Formulas
Range	Formula
F2:F5	F2	=[@[Promise Time]]-[@Time]/24

 

[jbrown021286]

Is this what you mean?

jbrown021286.xlsm
	A	B	C	D	E	F
1	Promise Time	Job	Time	Tag	Tech	track
2	9:45 AM	recall af cf	1	1138	me	8:45 AM
3	10:15 AM	ocr, bs	1	9560	j	9:15 AM
4	2:00 PM	recall af cf	1.3	4766		12:42 PM
5	5:00 PM	diag	1	7851		4:00 PM
Sheet1

Cell Formulas
Range	Formula
F2:F5	F2	=[@[Promise Time]]-[@Time]/24

that was it thanks for the help

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.