Formula to ignore empty cells when calculating Time

[stacyl14]

First off, I am new to this forum and I just want to thank every one in advance for any and all assistance. I have been searching the web for a week and have not even come close to figuring this out. Here is my problem: We have created a excel (2010) workbook to track workers who are late (see below) to determine lost production. I have managed to get it to calculate the time but only if I fill every cell with either the time the worker arrived or the scheduled work time. This throws off my calculation in column "Q" which I have set to calculate the number of times the worker has been late during the pay period (counts cells with data in them). What I need is a formula which will calculate the time difference (between arrival time and actual start time) in only the cells that have a time entered and ignoring the cells with no time entered, then total them in Column "R" (formatted [h]:mm) . Monday through Friday (columns: E,F,G,H,I,K,L,M,N,O) the start time is 07:30 (located in cell: W2), on Saturdays (columns: J,P) the start time is 06:30 (located in cell: X2).

I hope someone here can understand what I am trying to say.

Excel 2010

	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	2-Sep	3-Sep	4-Sep	5-Sep	6-Sep	6-Sep	9-Sep	10-Sep	11-Sep	12-Sep	13-Sep	14-Sep	TOTAL	Minutes Late	Lost Production Rate	Lost Production Value	Total Lost Production		Mon-Fri/ Start	Sat/ Start
2	7:35					6:50				8:05			3		$82.80	0	0		7:30	6:30
3													0			0
4													0			0

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula Q2 =COUNTA(E2:F2:G2:H2:I2:J2:K2:L2:M2:N2:O2:P2) Q3 =COUNTA(E3:F3:G3:H3:I3:J3:K3:L3:M3:N3:O3:P3) Q4 =COUNTA(E4:F4:G4:H4:I4:J4:K4:L4:M4:N4:O4:P4) T2 =R2*$S$2 U2 =SUM(T2:T155) T3 =R3*$S$2 T4 =R4*$S$2 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[stacyl14]

MikeWx,

I'm such a moron, I had the date set wrong in that column (J). Thanks a million for all of your help. Every thing is working perfectly now. I don't know if there is a way to give reputation points on this site, but you get a 100% rating in my book. Again, Thanks for all of your help.

 

[MikeWx]

I'm glad to here it is working the way you need it to. Thanks for your feedback.