Spreadsheet: 84255d1284289396-conditional-formatting-problem-truenorthfinder1-1-
Sheet: Sheet1

0 | Hemispere
0 | 152 | degrees | East | Longitude |  | +10 | GMT
 | 58 | minutes
 | 9120 | [NAME] in angle minutes
 | 9178 | site longitude in angle min total
stdmeridian | 150 | standard meridian
 | 9000 | standard meridian in minutes angle
 | 178 | difference in longitude minutes |  |  |  |  |  |  | 9 | hr
secdiff | 712 | difference in longitude seconds time |  |  |  |  |  |  | 27 | min | convert
 |  |  |  |  |  |  |  |  | 0 | sec | h:m:s
 |  |  |  |  |  |  |  |  |  |  | into sec
 |  |  |  |  |  |  |  |  | 32400
 |  |  |  |  |  |  |  |  | 1620
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 34020 | sec
12 | hour
43200 | seconds | 43200 = tw
 |  | (43200 = 12 hours in seconds) |  |  |  |  |  |  | 9.45
360 degrees in the world |  |  |  |  |  |  |  |  | 9 | hr
180 west + 180 east |  |  |  |  |  |  |  |  | 32400 |  | then
24 timezones |  |  |  |  |  |  |  |  | 1620 |  | sec
15 deg each hour |  |  |  |  |  |  |  |  | 27 |  | into h:m:s
each min of lattitude = 4 seconds of time |  |  |  |  |  |  |  |  | 27 | min
each deg of lattitude = 4 minutes of time |  |  |  |  |  |  |  |  | 1620
 |  |  |  |  |  |  |  |  | 0 | sec
15 deg for each timezone
1 hour for each timezone |  |  |  |  |  |  |  |  |  | can be deleted
60 min for each timezone |  |  |  |  |  |  |  |  |  | not part of program
3600 sec for each timezone
Ref only
not part of program
gmt | gmt
text | no | std |  |  | refrence only
 |  | meridian |  |  |  |  |  |  | +10
-12 | -12 | 180 | West | NO | International Date line |  |  |  | 10
-11 | -11 | 165 | West | NO | Samoa |  |  |  | 150
-10 | -10 | 150 | West | NO | Hawaii |  |  |  | East
-9 | -9 | 135 | West | NO | Alaska |  |  |  | NO | used to test for conditional formating
-8 | -8 | 120 | West | NO | San Fransisco |  |  | (pacific) |  | to allow 142.5 to fit in column
-7 | -7 | 105 | West | NO | Arizona |  |  | (mountain) |  | instead of 143
-6 | -6 | 90 | West | NO | Denver |  |  | (central)
-5 | -5 | 75 | West | NO | New York, Boston |  |  | (eastern)
-4 | -4 | 60 | West | NO | Canada
-3:30 | -3.5 | 52.5 | West | YES | Newfoundland
-3 | -3 | 45 | West | NO | [NAME]
-2 | -2 | 30 | West | NO | Mid Atlantic
-1 | -1 | 15 | West | NO | Azores
UTC | 0 |  | West |  | London
GMT | 0
Greenwich Mean Time | 0 |  | East | NO
+1 | 1 | 15 | East | NO | Paris
+2 | 2 | 30 | East | NO | Jerusalem
+3 | 3 | 45 | East | NO | Nairobi
+3:30 | 3.5 | 52.5 | East | YES | Tehran
+4 | 4 | 60 | East | NO | Baku
+4:30 | 4.5 | 67.5 | East | YES | Kabul
+5 | 5 | 75 | East | NO | Islambad
+5:30 | 5.5 | 82.5 | East | YES | New Delhi
+5:45 | 5.75 | 86.25 | East | YES | Kathmandu
+6 | 6 | 90 | East | NO | [NAME]
+6:30 | 6.5 | 97.5 | East | YES | Ragoon
+7 | 7 | 105 | East | NO | Krasnoyarsk
+8 | 8 | 120 | East | NO | perth
+9 | 9 | 135 | East | NO | Yakuts
+9:30 | 9.5 | 142.5 | East | YES | [NAME]
+10 | 10 | 150 | East | NO | brisbane
+11 | 11 | 165 | East | NO | New Caladonia
+12 | 12 | 180 | East | NO | Auckland
??? |  | ?
 | Time differnce between the sundial and a clock |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sundial can be 14 min slow |  |  |  |  |  |  | (feb)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and 16 min fast |  |  |  |  |  |  | (nov)
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec
DAY | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec | min | sec |  |  |  |  | On September one, trust the sun. |  |  |  |  |  |  |  |  |  | dial reads true
1 | -3 | -12 | -13 | -33 | -12 | -34 | -4 | -8 | 2 | 51 | 2 | 25 | -3 | -33 | -6 | -16 | 0 | -12 | 10 | 5 | 16 | 20 | 11 | 11 |  |  |  |  | On Christmas Day, you're OK.
2 | -3 | -40 | -13 | -41 | -12 | -23 | -3 | -50 | 2 | 59 | 2 | 16 | -3 | -45 | -6 | -13 | 0 | 7 | 10 | 24 | 16 | 22 | 10 | 49 |  |  |  |  | The mid of month four, add no more.
3 | -4 | -8 | -13 | -48 | -12 | -11 | -3 | -32 | 3 | 6 | 2 | 6 | -3 | -57 | -6 | -9 | 0 | 26 | 10 | 43 | 16 | 23 | 10 | 26 |  |  |  |  | On June fourteen, don't add a bean.
4 | -4 | -36 | -14 | -55 | -11 | -58 | -3 | -14 | 3 | 12 | 1 | 56 | -4 | -8 | -6 | -4 | 0 | 45 | 11 | 2 | 16 | 23 | 10 | 2
5 | -5 | -3 | -14 | -1 | -11 | -45 | -2 | -57 | 3 | 18 | 1 | 46 | -4 | -19 | -5 | -59 | 1 | 5 | 11 | 20 | 16 | 22 | 9 | 38
6 | -5 | -30 | -14 | -6 | -11 | -31 | -2 | -40 | 3 | 23 | 1 | 36 | -4 | -29 | -5 | -53 | 1 | 25 | 11 | 38 | 16 | 20 | 9 | 13
7 | -5 | -57 | -14 | -10 | -11 | -17 | -2 | -23 | 3 | 27 | 1 | 25 | -4 | -39 | -5 | -46 | 1 | 45 | 11 | 56 | 16 | 18 | 8 | 48 |  |  |  |  | When August begins, add seven little mins. |  |  |  |  |  |  |  |  |  | dial is slow
8 | -6 | -23 | -14 | -14 | -11 | -3 | -2 | -6 | 3 | 31 | 1 | 14 | -4 | -49 | -5 | -39 | 2 | 5 | 12 | 13 | 16 | 15 | 8 | 22 |  |  |  |  | For your [NAME] true, add a dozen and two. |  |  |  |  |  |  |  |  |  | clock is fast
9 | -6 | -49 | -14 | -16 | -10 | -48 | -1 | -49 | 3 | 35 | 1 | 3 | -4 | -58 | -5 | -31 | 2 | 26 | 12 | 30 | 16 | 11 | 7 | 56
10 | -7 | -14 | -14 | -18 | -10 | -33 | -1 | -32 | 3 | 38 | 0 | 51 | -5 | -7 | -5 | -23 | 2 | 47 | 12 | 46 | 16 | 6 | 7 | 29
11 | -7 | -38 | -14 | -19 | -10 | -18 | -1 | -16 | 3 | 40 | 0 | 39 | -5 | -16 | -5 | -14 | 3 | 8 | 13 | 2 | 16 | 0 | 7 | 2
12 | -8 | -2 | -14 | -20 | -10 | -2 | -1 | 0 | 3 | 42 | 0 | 27 | -5 | -24 | -5 | -5 | 3 | 29 | 13 | 18 | 15 | 53 | 6 | 34 |  |  |  |  | Come Halloween, subtract sixteen. |  |  |  |  |  |  |  |  |  | dial is fast
13 | -8 | -25 | -14 | -19 | -9 | -46 | 0 | -44 | 3 | 44 | 0 | 15 | -5 | -32 | -4 | -55 | 3 | 50 | 13 | 33 | 15 | 46 | 6 | 6 |  |  |  |  | At the mid of May, take four away. |  |  |  |  |  |  |  |  |  | clock is slow
14 | -8 | -48 | -14 | -18 | -9 | -30 | 0 | -29 | 3 | 44 | 0 | 3 | -5 | -39 | -4 | -44 | 4 | 11 | 13 | 47 | 15 | 37 | 5 | 38
15 | -9 | -10 | -14 | -16 | -9 | -13 | 0 | -14 | 3 | 44 | 0 | -10 | -5 | -46 | -4 | -33 | 4 | 32 | 14 | 1 | 15 | 28 | 5 | 9
16 | -9 | -32 | -14 | -13 | -8 | -56 | 0 | 1 | 3 | 44 | 0 | -23 | -5 | -52 | -4 | -21 | 4 | 53 | 14 | 14 | 15 | 18 | 4 | 40 |  |  |  |  | if you were to read 11 AM on your sundial in mid-February
17 | -9 | -52 | -14 | -10 | -8 | -39 | 0 | 15 | 3 | 43 | 0 | -36 | -5 | -58 | -4 | -9 | 5 | 14 | 14 | 27 | 15 | 7 | 4 | 11 |  |  |  |  | then it's actually 11 AM minus about 14 minutes (11:00 plus a -00:14),
18 | -10 | -12 | -14 | -6 | -8 | -22 | 0 | 29 | 3 | 41 | 0 | -49 | -6 | -3 | -3 | -57 | 5 | 35 | 14 | 39 | 14 | 56 | 3 | 42 |  |  |  |  | or about 10:46 AM. Similarly, if you had an appointment
19 | -10 | -32 | -14 | -1 | -8 | -4 | 0 | 43 | 3 | 39 | -1 | -2 | -6 | -8 | -3 | -44 | 5 | 56 | 14 | 51 | 14 | 43 | 3 | 13 |  |  |  |  | at noon in early November and your sundial indicated noon,
20 | -10 | -50 | -13 | -55 | -7 | -46 | 0 | 56 | 3 | 37 | -1 | -15 | -6 | -12 | -3 | -30 | 6 | 18 | 15 | 2 | 14 | 30 | 2 | 43 |  |  |  |  | then the wall clock time would be noon plus about 16 minutes or 12:16 --so you're already late!
21 | -11 | -8 | -13 | -49 | -7 | -28 | 1 | 0 | 3 | 34 | -1 | -28 | -6 | -15 | -3 | -16 | 6 | 40 | 15 | 12 | 14 | 16 | 2 | 13
22 | -11 | -25 | -13 | -42 | -7 | -10 | 1 | 21 | 3 | 30 | -1 | -41 | -6 | -18 | -3 | -1 | 7 | 1 | 15 | 22 | 14 | 1 | 1 | 43
23 | -11 | -41 | -13 | -35 | -6 | -52 | 1 | 33 | 3 | 24 | -1 | -54 | -6 | -20 | -2 | -46 | 7 | 22 | 15 | 31 | 13 | 45 | 1 | 13
24 | -11 | -57 | -13 | -27 | -6 | -34 | 1 | 45 | 3 | 21 | -2 | -7 | -6 | -22 | -2 | -30 | 7 | 43 | 15 | 40 | 13 | 28 | 0 | 43
25 | -12 | -12 | -13 | -18 | -6 | -16 | 1 | 56 | 3 | 16 | -2 | -20 | -6 | -24 | -2 | -14 | 8 | 4 | 15 | 47 | 13 | 11 | 0 | 13
26 | -12 | -26 | -13 | -9 | -5 | -58 | 2 | 6 | 3 | 10 | -2 | -33 | -6 | -25 | -1 | -58 | 8 | 25 | 15 | 54 | 12 | 53 | 0 | -17
27 | -12 | -39 | -13 | -59 | -5 | -40 | 2 | 16 | 3 | 3 | -2 | -45 | -6 | -25 | -1 | -41 | 8 | 46 | 16 | 1 | 12 | 34 | 0 | -47
28 | -12 | -51 | -13 | -48 | -5 | -21 | 2 | 26 | 2 | 56 | -2 | -57 | -6 | -24 | -1 | -24 | 9 | 6 | 16 | 6 | 12 | 14 | -1 | -16
29 | -13 | -3 | -13 | -42 | -5 | -2 | 2 | 35 | 2 | 49 | -3 | -9 | -6 | -23 | -1 | -7 | 9 | 26 | 16 | 11 | 11 | 54 | -2 | -14
30 | -13 | -14 | x |  | -4 | -44 | 2 | 43 | 2 | 41 | -3 | -21 | -6 | -21 | 0 | -49 | 9 | 46 | 16 | 15 | 11 | 33 | -2 | -43
31 | -13 | -24 | x |  | -4 | -26 | x | x | 2 | 33 | x | x | -6 | -19 | 0 | -31 |  | x | 16 | 18 | x | x
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec