Copy 5 of Time recording ver20200601

	A	B	C	D	G	H	I	J	L	M	N	O	P	Q	R	S	U	V	W
1	Select C5 (green) before the start, and, on start signal, touch the graphic. Repeat for Div 2 and 3.																To allow for 12 hr adjustment
2						Calculations						Dec	Dec	Elapsed	H'cap	Corr.	Elapsed	H'cap	Corr.
3				Crossed	Finished	Start times			Finish times			start	finish	time		time	time (min)		time
4	Vessel	Sail no		St line		Aus H	M	S	Aus H	M	S								(min)
5	Division 1 start ----->		2:06:55 AM EDT			6	6	55
6	Tintagel		2:06:55 AM EDT	5:44:12 AM EST	8:06:26 AM EDT	6	6	55	12	6	26	366.92	726.43	359.52	0.5659	203.45	359.52	0.5659	203.45
7	Muriel Elizabeth		2:06:55 AM EDT	5:43:28 AM EST	12:35:30 AM EST	6	6	55	16	35	30	366.92	995.50	628.58	0.559	351.38	628.58	0.559	351.38
8	Rosie		2:06:55 AM EDT	5:43:35 AM EST	8:07:22 AM EDT	6	6	55	12	7	22	366.92	727.37	360.45	0.5401	194.68	360.45	0.5401	194.68
9	Maud		2:06:55 AM EDT	12:45:42 AM EDT	4:39:19 PM EST	6	6	55	8	39	19	366.92	519.32	152.40	0.54	82.30	152.40	0.54	82.30
10	Drizabone		2:06:55 AM EDT	12:18:00 AM EDT	4:39:44 PM EST	6	6	55	8	39	44	366.92	519.73	152.82	0.5688	86.92	152.82	0.5688	86.92
11	Indulgence	Q36	2:06:55 AM EDT	4:42:03 PM EST		6	6	55	#VALUE!	#VALUE!	#VALUE!	366.92	#VALUE!	#VALUE!	0.5505	#VALUE!	#VALUE!	0.5505	#VALUE!
12	Division 2 start ----->		9:11:05 PM EST			13	11	5
13	Valentine		9:11:05 PM EST	9:40:58 PM EDT	12:35:46 AM EST	13	11	5	16	35	46	791.08	995.77	204.68	0.6405	131.10	204.68	0.6405	131.10
14	Boomaroo	Q23	9:11:05 PM EST	9:41:09 PM EDT		13	11	5	#VALUE!	#VALUE!	#VALUE!	791.08	#VALUE!	#VALUE!	0.6651	#VALUE!	#VALUE!	0.6651	#VALUE!
15	Tiercel	Q241	9:11:05 PM EST	9:14:03 PM EDT	1:12:58 AM EST	13	11	5	5	12	58	791.08	312.97	-478.12	0.6489	-310.25	241.88	0.6489	156.96
16	Other Div 2		9:11:05 PM EST	11:20:00 PM EDT		13	11	5	#VALUE!	#VALUE!	#VALUE!	791.08	#VALUE!	#VALUE!	0.6	#VALUE!	#VALUE!	0.6	#VALUE!
17	Division 3 start ------->		9:11:15 PM EST			13	11	15
18	Imagine		9:11:15 PM EST	1:20:35 AM EDT		13	11	15	#VALUE!	#VALUE!	#VALUE!	791.25	#VALUE!	#VALUE!	0.7862	#VALUE!	#VALUE!	0.7862	#VALUE!
19	Sundance	Q6000	9:11:15 PM EST	1:20:47 AM EDT	9:11:51 PM EST	13	11	15	13	11	51	791.25	791.85	0.60	0.8025	0.48	0.60	0.8025	0.48
20
21	Admin:- Time zone correction 2 or 4 ->	4				5:19:31 PM EST
22	4 in summer, 2 in winter
23	or even 3 depending on overseas daylight saving?
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100