Sophisticated Chalange calculating business hours between two dates in Excel

[jamilm]

Gurus and Masters of Excel

Time and Date math is always brutal.


i have the below worksheet also uploaded in the link https://skydrive.live.com/redir?resid=D7C00A2BF29043E0!252

in Column E, i would like to calculate the working/business hours spent in response to the received requests from clients. the responders names are also provided.
i tried this by myself with the networkingdays, mod, midian, small, round, int, fucntions, but somehow i failed . i did a bit of googling and in ozgrid forum i found similar case which is a bit different, i uploaded it, in the https://skydrive.live.com/redir?resid=D7C00A2BF29043E0!254

now the one i found in ozgrid forum Work Days And Hours Between Two Dates & Times - Page 2 has the dates sorted in chronological order, but my sheet, the dates and not sorted in chronological order. it is different as you can see in the sheet below.

Now, in column E of my worksheet, i would like a formula to get me the working/business hours spent in responding to each incoming received request from the clients.
i hope , i made is clear, otherwise if you require more elaboration, please let me know.


My worksheet

Excel 2010
	A	B	C	D	E	F	G	H
1	Day start	Day End	Holiday list		also exclude all Saturdays and sundays which are weekends
2	9:00	17:30	5/21/2013
3
4
5
6
7
8
9	Case/tasks	Correspondences	Dates&Times	Received/Actioned	Interval Working Hours spent		Lawyers	Clients
10	Case number 1515100	Mike	5/7/2013 0:59	Actioned			James	Any text value any name
11		xxxxxxx	5/7/2013 1:04	Received			Nickolas	xxxxxxxxxxx
12		Sweenie	5/10/2013 11:37	Actioned			Benjamin	xxxxxxxx
13		xxxxxxx	5/7/2013 18:51	Received			Mike	xxxxxxxxx
14		James	5/6/2013 6:32	Actioned			Lora	xxxxxxxxxxxxxxx
15		Sandy	5/10/2013 3:45	Actioned			Sweenie	xxxxxxxxxxxxxxxx
16		Nickolas	5/13/2013 9:27	Actioned			Sandy	xxxxxxxxxxxxxxx
17		xxxxxxx	5/3/2013 9:47	Received
18		xxxxxxx	5/6/2013 18:32	Received
19		xxxxxxx	5/10/2013 18:41	Received
20	Case number 1515100	Lora	5/17/2013 11:22	Actioned
21		Benjamin	5/6/2013 16:26	Actioned
22		xxxxxxx	5/7/2013 8:56	Received
23		Mike	5/16/2013 15:03	Actioned
24		James	5/16/2013 16:03	Actioned
25		James	5/7/2013 9:04	Actioned
26		xxxxxxx	5/8/2013 11:25	Received
27		xxxxxxx	5/16/2013 15:07	Received
28		xxxxxxx	4/23/2013 11:58	Received
29		xxxxxxx	5/6/2013 17:13	Received
30		xxxxxxx	5/7/2013 9:02	Received
31		xxxxxxx	5/16/2013 16:30	Received
32	Case number 1515100	xxxxxxx	5/16/2013 11:09	Received
33		xxxxxxx	5/16/2013 15:51	Received
34		xxxxxxx	5/14/2013 15:30	Received
35		Lora	5/14/2013 16:20	Actioned
36		Mike	5/16/2013 14:35	Actioned
37		Sandy	5/21/2013 15:20	Actioned
Sheet1

Cell Formulas
Range	Formula
D10	=IF(OR(B10="Mike",B10="Nickolas",B10="Benjamin",B10="Lora",B10="Sweenie",B10="Sandy",B10="James"),"Actioned","Received")
D11	=IF(OR(B11="Mike",B11="Nickolas",B11="Benjamin",B11="Lora",B11="Sweenie",B11="Sandy",B11="James"),"Actioned","Received")
D12	=IF(OR(B12="Mike",B12="Nickolas",B12="Benjamin",B12="Lora",B12="Sweenie",B12="Sandy",B12="James"),"Actioned","Received")
D13	=IF(OR(B13="Mike",B13="Nickolas",B13="Benjamin",B13="Lora",B13="Sweenie",B13="Sandy",B13="James"),"Actioned","Received")
D14	=IF(OR(B14="Mike",B14="Nickolas",B14="Benjamin",B14="Lora",B14="Sweenie",B14="Sandy",B14="James"),"Actioned","Received")
D15	=IF(OR(B15="Mike",B15="Nickolas",B15="Benjamin",B15="Lora",B15="Sweenie",B15="Sandy",B15="James"),"Actioned","Received")
D16	=IF(OR(B16="Mike",B16="Nickolas",B16="Benjamin",B16="Lora",B16="Sweenie",B16="Sandy",B16="James"),"Actioned","Received")
D17	=IF(OR(B17="Mike",B17="Nickolas",B17="Benjamin",B17="Lora",B17="Sweenie",B17="Sandy",B17="James"),"Actioned","Received")
D18	=IF(OR(B18="Mike",B18="Nickolas",B18="Benjamin",B18="Lora",B18="Sweenie",B18="Sandy",B18="James"),"Actioned","Received")
D19	=IF(OR(B19="Mike",B19="Nickolas",B19="Benjamin",B19="Lora",B19="Sweenie",B19="Sandy",B19="James"),"Actioned","Received")
D20	=IF(OR(B20="Mike",B20="Nickolas",B20="Benjamin",B20="Lora",B20="Sweenie",B20="Sandy",B20="James"),"Actioned","Received")
D21	=IF(OR(B21="Mike",B21="Nickolas",B21="Benjamin",B21="Lora",B21="Sweenie",B21="Sandy",B21="James"),"Actioned","Received")
D22	=IF(OR(B22="Mike",B22="Nickolas",B22="Benjamin",B22="Lora",B22="Sweenie",B22="Sandy",B22="James"),"Actioned","Received")
D23	=IF(OR(B23="Mike",B23="Nickolas",B23="Benjamin",B23="Lora",B23="Sweenie",B23="Sandy",B23="James"),"Actioned","Received")
D24	=IF(OR(B24="Mike",B24="Nickolas",B24="Benjamin",B24="Lora",B24="Sweenie",B24="Sandy",B24="James"),"Actioned","Received")
D25	=IF(OR(B25="Mike",B25="Nickolas",B25="Benjamin",B25="Lora",B25="Sweenie",B25="Sandy",B25="James"),"Actioned","Received")
D26	=IF(OR(B26="Mike",B26="Nickolas",B26="Benjamin",B26="Lora",B26="Sweenie",B26="Sandy",B26="James"),"Actioned","Received")
D27	=IF(OR(B27="Mike",B27="Nickolas",B27="Benjamin",B27="Lora",B27="Sweenie",B27="Sandy",B27="James"),"Actioned","Received")
D28	=IF(OR(B28="Mike",B28="Nickolas",B28="Benjamin",B28="Lora",B28="Sweenie",B28="Sandy",B28="James"),"Actioned","Received")
D29	=IF(OR(B29="Mike",B29="Nickolas",B29="Benjamin",B29="Lora",B29="Sweenie",B29="Sandy",B29="James"),"Actioned","Received")
D30	=IF(OR(B30="Mike",B30="Nickolas",B30="Benjamin",B30="Lora",B30="Sweenie",B30="Sandy",B30="James"),"Actioned","Received")
D31	=IF(OR(B31="Mike",B31="Nickolas",B31="Benjamin",B31="Lora",B31="Sweenie",B31="Sandy",B31="James"),"Actioned","Received")
D32	=IF(OR(B32="Mike",B32="Nickolas",B32="Benjamin",B32="Lora",B32="Sweenie",B32="Sandy",B32="James"),"Actioned","Received")
D33	=IF(OR(B33="Mike",B33="Nickolas",B33="Benjamin",B33="Lora",B33="Sweenie",B33="Sandy",B33="James"),"Actioned","Received")
D34	=IF(OR(B34="Mike",B34="Nickolas",B34="Benjamin",B34="Lora",B34="Sweenie",B34="Sandy",B34="James"),"Actioned","Received")
D35	=IF(OR(B35="Mike",B35="Nickolas",B35="Benjamin",B35="Lora",B35="Sweenie",B35="Sandy",B35="James"),"Actioned","Received")
D36	=IF(OR(B36="Mike",B36="Nickolas",B36="Benjamin",B36="Lora",B36="Sweenie",B36="Sandy",B36="James"),"Actioned","Received")
D37	=IF(OR(B37="Mike",B37="Nickolas",B37="Benjamin",B37="Lora",B37="Sweenie",B37="Sandy",B37="James"),"Actioned","Received")

THE WORKSHEET I FOUND IN OZGRID FORUM IS BELOW

Excel 2010
	A	B	C	D
1	Day start	Day End	Holiday list
2	8:30	17:30	3/1/2008
3
4
5
6
7
8
9				>>
10	Date Received	Date Actioned		Response time Date Actioned -Received (hh:mm)
11	25/02/2008 03:14 PM	26/02/2008 10:12 AM		3:58
12	26/02/2008 06:36 AM	04/03/2008 04:21 PM		52:51
13	01/03/2008 12:43 AM	02/03/2008 12:33 AM		0:00
14	04/03/2008 08:58 AM	04/03/2008 11:55 AM		2:57
15	04/03/2008 09:55 AM	04/03/2008 03:27 PM		5:32
16	02/03/2008 01:00 AM	04/03/2008 04:23 PM		16:53
17	04/03/2008 05:20 AM	04/03/2008 04:27 PM		7:57
18	03/03/2008 03:13 PM	04/03/2008 04:30 PM		10:17
19	05/03/2008 11:54 AM	05/03/2008 12:09 PM		0:15
20	29/02/2008 05:54 PM	04/03/2008 04:38 PM		17:08
21	05/03/2008 11:54 AM	05/03/2008 12:12 PM		0:18
22	05/03/2008 12:38 PM	06/03/2008 03:13 PM		11:35
23	05/03/2008 12:51 PM	05/03/2008 04:45 PM		3:54
24	05/03/2008 01:23 PM	05/03/2008 04:42 PM		3:19
25	05/03/2008 04:26 PM	26/03/2008 10:50 PM		136:04
26	06/03/2008 08:02 AM	06/03/2008 03:48 PM		7:18
27	22/02/2008 04:29 PM	26/02/2008 09:21 AM		10:52
28	06/03/2008 09:13 AM	06/03/2008 02:44 PM		5:31
29	06/03/2008 02:59 PM	06/03/2008 03:35 PM		0:36
30	06/03/2008 03:03 PM	11/03/2008 11:49 AM		23:46
31	05/03/2008 03:06 PM	05/03/2008 04:10 PM		1:04
32	06/03/2008 08:02 PM	07/03/2008 08:30 AM		0:00
Sheet1

Cell Formulas
Range	Formula
D11	=(NETWORKDAYS(A11,B11,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B11,B11,C$2),MEDIAN(MOD(B11,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A11,A11,C$2)*MOD(A11,1),B$2,A$2)
D12	=(NETWORKDAYS(A12,B12,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B12,B12,C$2),MEDIAN(MOD(B12,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A12,A12,C$2)*MOD(A12,1),B$2,A$2)
D13	=(NETWORKDAYS(A13,B13,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B13,B13,C$2),MEDIAN(MOD(B13,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A13,A13,C$2)*MOD(A13,1),B$2,A$2)
D14	=(NETWORKDAYS(A14,B14,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B14,B14,C$2),MEDIAN(MOD(B14,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A14,A14,C$2)*MOD(A14,1),B$2,A$2)
D15	=(NETWORKDAYS(A15,B15,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B15,B15,C$2),MEDIAN(MOD(B15,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A15,A15,C$2)*MOD(A15,1),B$2,A$2)
D16	=(NETWORKDAYS(A16,B16,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B16,B16,C$2),MEDIAN(MOD(B16,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A16,A16,C$2)*MOD(A16,1),B$2,A$2)
D17	=(NETWORKDAYS(A17,B17,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B17,B17,C$2),MEDIAN(MOD(B17,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A17,A17,C$2)*MOD(A17,1),B$2,A$2)
D18	=(NETWORKDAYS(A18,B18,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B18,B18,C$2),MEDIAN(MOD(B18,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A18,A18,C$2)*MOD(A18,1),B$2,A$2)
D19	=(NETWORKDAYS(A19,B19,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B19,B19,C$2),MEDIAN(MOD(B19,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A19,A19,C$2)*MOD(A19,1),B$2,A$2)
D20	=(NETWORKDAYS(A20,B20,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B20,B20,C$2),MEDIAN(MOD(B20,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A20,A20,C$2)*MOD(A20,1),B$2,A$2)
D21	=(NETWORKDAYS(A21,B21,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B21,B21,C$2),MEDIAN(MOD(B21,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A21,A21,C$2)*MOD(A21,1),B$2,A$2)
D22	=(NETWORKDAYS(A22,B22,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B22,B22,C$2),MEDIAN(MOD(B22,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A22,A22,C$2)*MOD(A22,1),B$2,A$2)
D23	=(NETWORKDAYS(A23,B23,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B23,B23,C$2),MEDIAN(MOD(B23,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A23,A23,C$2)*MOD(A23,1),B$2,A$2)
D24	=(NETWORKDAYS(A24,B24,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B24,B24,C$2),MEDIAN(MOD(B24,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A24,A24,C$2)*MOD(A24,1),B$2,A$2)
D25	=(NETWORKDAYS(A25,B25,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B25,B25,C$2),MEDIAN(MOD(B25,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A25,A25,C$2)*MOD(A25,1),B$2,A$2)
D26	=(NETWORKDAYS(A26,B26,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B26,B26,C$2),MEDIAN(MOD(B26,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A26,A26,C$2)*MOD(A26,1),B$2,A$2)
D27	=(NETWORKDAYS(A27,B27,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B27,B27,C$2),MEDIAN(MOD(B27,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A27,A27,C$2)*MOD(A27,1),B$2,A$2)
D28	=(NETWORKDAYS(A28,B28,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B28,B28,C$2),MEDIAN(MOD(B28,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A28,A28,C$2)*MOD(A28,1),B$2,A$2)
D29	=(NETWORKDAYS(A29,B29,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B29,B29,C$2),MEDIAN(MOD(B29,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A29,A29,C$2)*MOD(A29,1),B$2,A$2)
D30	=(NETWORKDAYS(A30,B30,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B30,B30,C$2),MEDIAN(MOD(B30,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A30,A30,C$2)*MOD(A30,1),B$2,A$2)
D31	=(NETWORKDAYS(A31,B31,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B31,B31,C$2),MEDIAN(MOD(B31,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A31,A31,C$2)*MOD(A31,1),B$2,A$2)
D32	=(NETWORKDAYS(A32,B32,C$2)-1)*(B$2-A$2)+IF(NETWORKDAYS(B32,B32,C$2),MEDIAN(MOD(B32,1),B$2,A$2),B$2)-MEDIAN(NETWORKDAYS(A32,A32,C$2)*MOD(A32,1),B$2,A$2)

 

[jamilm]

just to add that there is a typo in my sheet. that i want to correct here. is that the case numbers for each color shown is different.

Excel 2010
	A	B	C	D	E	F	G	H
1	Day start	Day End	Holiday list		also exclude all Saturdays and sundays which are weekends
2	9:00	17:30	5/21/2013
3
4
5
6
7
8
9	Case/tasks	Correspondences	Dates&Times	Received/Actioned	Interval Working Hours spent		Lawyers	Clients
10	Case number 1515100	Mike	5/7/2013 0:59	Actioned			James	Any text value any name
11		xxxxxxx	5/7/2013 1:04	Received			Nickolas	xxxxxxxxxxx
12		Sweenie	5/10/2013 11:37	Actioned			Benjamin	xxxxxxxx
13		xxxxxxx	5/7/2013 18:51	Received			Mike	xxxxxxxxx
14		James	5/6/2013 6:32	Actioned			Lora	xxxxxxxxxxxxxxx
15		Sandy	5/10/2013 3:45	Actioned			Sweenie	xxxxxxxxxxxxxxxx
16		Nickolas	5/13/2013 9:27	Actioned			Sandy	xxxxxxxxxxxxxxx
17		xxxxxxx	5/3/2013 9:47	Received
18		xxxxxxx	5/6/2013 18:32	Received
19		xxxxxxx	5/10/2013 18:41	Received
20	Case number 1515165	Lora	5/17/2013 11:22	Actioned
21		Benjamin	5/6/2013 16:26	Actioned
22		xxxxxxx	5/7/2013 8:56	Received
23		Mike	5/16/2013 15:03	Actioned
24		James	5/16/2013 16:03	Actioned
25		James	5/7/2013 9:04	Actioned
26		xxxxxxx	5/8/2013 11:25	Received
27		xxxxxxx	5/16/2013 15:07	Received
28		xxxxxxx	4/23/2013 11:58	Received
29		xxxxxxx	5/6/2013 17:13	Received
30		xxxxxxx	5/7/2013 9:02	Received
31		xxxxxxx	5/16/2013 16:30	Received
32	Case number 1515199	xxxxxxx	5/16/2013 11:09	Received
33		xxxxxxx	5/16/2013 15:51	Received
34		xxxxxxx	5/14/2013 15:30	Received
35		Lora	5/14/2013 16:20	Actioned
36		Mike	5/16/2013 14:35	Actioned
37		Sandy	5/21/2013 15:20	Actioned
Sheet1

Cell Formulas
Range	Formula
D10	=IF(OR(B10="Mike",B10="Nickolas",B10="Benjamin",B10="Lora",B10="Sweenie",B10="Sandy",B10="James"),"Actioned","Received")
D11	=IF(OR(B11="Mike",B11="Nickolas",B11="Benjamin",B11="Lora",B11="Sweenie",B11="Sandy",B11="James"),"Actioned","Received")
D12	=IF(OR(B12="Mike",B12="Nickolas",B12="Benjamin",B12="Lora",B12="Sweenie",B12="Sandy",B12="James"),"Actioned","Received")
D13	=IF(OR(B13="Mike",B13="Nickolas",B13="Benjamin",B13="Lora",B13="Sweenie",B13="Sandy",B13="James"),"Actioned","Received")
D14	=IF(OR(B14="Mike",B14="Nickolas",B14="Benjamin",B14="Lora",B14="Sweenie",B14="Sandy",B14="James"),"Actioned","Received")
D15	=IF(OR(B15="Mike",B15="Nickolas",B15="Benjamin",B15="Lora",B15="Sweenie",B15="Sandy",B15="James"),"Actioned","Received")
D16	=IF(OR(B16="Mike",B16="Nickolas",B16="Benjamin",B16="Lora",B16="Sweenie",B16="Sandy",B16="James"),"Actioned","Received")
D17	=IF(OR(B17="Mike",B17="Nickolas",B17="Benjamin",B17="Lora",B17="Sweenie",B17="Sandy",B17="James"),"Actioned","Received")
D18	=IF(OR(B18="Mike",B18="Nickolas",B18="Benjamin",B18="Lora",B18="Sweenie",B18="Sandy",B18="James"),"Actioned","Received")
D19	=IF(OR(B19="Mike",B19="Nickolas",B19="Benjamin",B19="Lora",B19="Sweenie",B19="Sandy",B19="James"),"Actioned","Received")
D20	=IF(OR(B20="Mike",B20="Nickolas",B20="Benjamin",B20="Lora",B20="Sweenie",B20="Sandy",B20="James"),"Actioned","Received")
D21	=IF(OR(B21="Mike",B21="Nickolas",B21="Benjamin",B21="Lora",B21="Sweenie",B21="Sandy",B21="James"),"Actioned","Received")
D22	=IF(OR(B22="Mike",B22="Nickolas",B22="Benjamin",B22="Lora",B22="Sweenie",B22="Sandy",B22="James"),"Actioned","Received")
D23	=IF(OR(B23="Mike",B23="Nickolas",B23="Benjamin",B23="Lora",B23="Sweenie",B23="Sandy",B23="James"),"Actioned","Received")
D24	=IF(OR(B24="Mike",B24="Nickolas",B24="Benjamin",B24="Lora",B24="Sweenie",B24="Sandy",B24="James"),"Actioned","Received")
D25	=IF(OR(B25="Mike",B25="Nickolas",B25="Benjamin",B25="Lora",B25="Sweenie",B25="Sandy",B25="James"),"Actioned","Received")
D26	=IF(OR(B26="Mike",B26="Nickolas",B26="Benjamin",B26="Lora",B26="Sweenie",B26="Sandy",B26="James"),"Actioned","Received")
D27	=IF(OR(B27="Mike",B27="Nickolas",B27="Benjamin",B27="Lora",B27="Sweenie",B27="Sandy",B27="James"),"Actioned","Received")
D28	=IF(OR(B28="Mike",B28="Nickolas",B28="Benjamin",B28="Lora",B28="Sweenie",B28="Sandy",B28="James"),"Actioned","Received")
D29	=IF(OR(B29="Mike",B29="Nickolas",B29="Benjamin",B29="Lora",B29="Sweenie",B29="Sandy",B29="James"),"Actioned","Received")
D30	=IF(OR(B30="Mike",B30="Nickolas",B30="Benjamin",B30="Lora",B30="Sweenie",B30="Sandy",B30="James"),"Actioned","Received")
D31	=IF(OR(B31="Mike",B31="Nickolas",B31="Benjamin",B31="Lora",B31="Sweenie",B31="Sandy",B31="James"),"Actioned","Received")
D32	=IF(OR(B32="Mike",B32="Nickolas",B32="Benjamin",B32="Lora",B32="Sweenie",B32="Sandy",B32="James"),"Actioned","Received")
D33	=IF(OR(B33="Mike",B33="Nickolas",B33="Benjamin",B33="Lora",B33="Sweenie",B33="Sandy",B33="James"),"Actioned","Received")
D34	=IF(OR(B34="Mike",B34="Nickolas",B34="Benjamin",B34="Lora",B34="Sweenie",B34="Sandy",B34="James"),"Actioned","Received")
D35	=IF(OR(B35="Mike",B35="Nickolas",B35="Benjamin",B35="Lora",B35="Sweenie",B35="Sandy",B35="James"),"Actioned","Received")
D36	=IF(OR(B36="Mike",B36="Nickolas",B36="Benjamin",B36="Lora",B36="Sweenie",B36="Sandy",B36="James"),"Actioned","Received")
D37	=IF(OR(B37="Mike",B37="Nickolas",B37="Benjamin",B37="Lora",B37="Sweenie",B37="Sandy",B37="James"),"Actioned","Received")