ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Current Day and Night Limitation Time >>18:00:0006:00:00
2
FromTo
3
Main Periods of TimeEarly night time00:00:0005:59:59
4
Early day time06:00:0012:00:00
5
Late day time12:00:0017:59:59
6
Late night time18:00:0023:59:59
7
8
ScenariosEnd Time always greater than Start TimeWill be provided ManuallyManual CalculationProblem
9
DateDown TimeRestored TimeStart TimeEnd TimeDay Time EndsDay Time StartsDay Time Duration (Hours)Night Time Duration (Hours)Total DurationDay Time Duration (Formula)Night Time Duration (Formula)
10
Same DateEarly night timeEarly night time12/09/2024 02:00:0012/09/2024 05:05:0018:00:0006:00:000.0003.0833.083
11
Same DateEarly night timeEarly day time12/09/2024 02:00:0012/09/2024 07:05:0018:00:0006:00:001.0834.0005.083
12
Same DateEarly night timeLate day time12/09/2024 02:00:0012/09/2024 13:05:0018:00:0006:00:007.0834.00011.083
13
Same DateEarly night timeLate night time12/09/2024 02:00:0012/09/2024 20:05:0018:00:0006:00:0012.0006.08318.083
15
Same DateEarly day timeEarly day time12/09/2024 07:05:0012/09/2024 08:05:0018:00:0006:00:001.0000.0001.000
16
Same DateEarly day timeLate day time12/09/2024 07:05:0012/09/2024 13:05:0018:00:0006:00:006.0000.0006.000
17
Same DateEarly day timeLate night time12/09/2024 07:05:0012/09/2024 20:05:0018:00:0006:00:0010.9172.08313.000
20
Same DateLate day timeLate day time12/09/2024 13:05:0012/09/2024 15:05:0018:00:0006:00:002.0000.0002.000
21
Same DateLate day timeLate night time12/09/2024 13:05:0012/09/2024 20:05:0018:00:0006:00:004.9172.0837.000
25
Same DateLate night timeLate night time12/09/2024 20:05:0012/09/2024 22:05:0018:00:0006:00:000.0002.0002.000
26
Not Same Date (Over 1 Day or More)Early night timeEarly night time12/09/2024 02:00:0014/09/2024 05:05:0018:00:0006:00:0024.00027.08351.083
27
Not Same Date (Over 1 Day or More)Early night timeEarly day time12/09/2024 02:00:0014/09/2024 07:05:0018:00:0006:00:0025.08328.00053.083
28
Not Same Date (Over 1 Day or More)Early night timeLate day time12/09/2024 02:00:0014/09/2024 13:05:0018:00:0006:00:0031.08328.00059.083
29
Not Same Date (Over 1 Day or More)Early night timeLate night time12/09/2024 02:00:0014/09/2024 22:05:0018:00:0006:00:0036.00032.08368.083
30
Not Same Date (Over 1 Day or More)Early day timeEarly night time12/09/2024 07:05:0013/09/2024 05:05:0018:00:0006:00:0010.91711.08322.000
31
Not Same Date (Over 1 Day or More)Early day timeEarly day time12/09/2024 07:05:0013/09/2024 07:05:0018:00:0006:00:0012.00012.00024.000
32
Not Same Date (Over 1 Day or More)Early day timeLate day time12/09/2024 07:05:0013/09/2024 13:05:0018:00:0006:00:0018.00012.00030.000
33
Not Same Date (Over 1 Day or More)Early day timeLate night time12/09/2024 07:05:0013/09/2024 22:05:0018:00:0006:00:0022.91716.08339.000
34
Not Same Date (Over 1 Day or More)Late day timeEarly night time12/09/2024 13:05:0016/09/2024 05:05:0018:00:0006:00:0040.91747.08388.000
35
Not Same Date (Over 1 Day or More)Late day timeEarly day time12/09/2024 13:05:0016/09/2024 07:05:0018:00:0006:00:0042.00048.00090.000
36
Not Same Date (Over 1 Day or More)Late day timeLate day time12/09/2024 13:05:0016/09/2024 13:05:0018:00:0006:00:0048.00048.00096.000
37
Not Same Date (Over 1 Day or More)Late day timeLate night time12/09/2024 13:05:0016/09/2024 22:05:0018:00:0006:00:0052.91752.083105.000
38
Not Same Date (Over 1 Day or More)Late night timeEarly night time12/09/2024 20:05:0016/09/2024 05:05:0018:00:0006:00:0036.00045.00081.000
39
Not Same Date (Over 1 Day or More)Late night timeEarly day time12/09/2024 20:05:0016/09/2024 07:05:0018:00:0006:00:0037.08345.91783.000
40
Not Same Date (Over 1 Day or More)Late night timeLate day time12/09/2024 20:05:0016/09/2024 13:05:0018:00:0006:00:0043.08345.91789.000
41
Not Same Date (Over 1 Day or More)Late night timeLate night time12/09/2024 20:05:0016/09/2024 22:05:0018:00:0006:00:0048.00050.00098.000
42
RandomRandomRandom16/08/2024 09:13:2706/09/2024 17:36:0818:00:0006:00:00512.380
43
RandomRandomRandom16/08/2024 09:13:2706/09/2024 17:36:0818:00:0006:00:00512.380
44
RandomRandomRandom21/07/2024 18:15:1006/09/2024 16:12:1618:00:0006:00:001125.950
45
RandomRandomRandom21/07/2024 18:11:4906/09/2024 16:12:0718:00:0006:00:001126.010
46
RandomRandomRandom03/09/2024 08:23:1506/09/2024 15:42:5518:00:0006:00:0079.330
47
RandomRandomRandom03/09/2024 08:23:1206/09/2024 15:42:5518:00:0006:00:0079.330
48
RandomRandomRandom03/09/2024 08:23:0806/09/2024 13:16:5818:00:0006:00:0076.900
49
RandomRandomRandom03/09/2024 07:26:5706/09/2024 13:18:5518:00:0006:00:0077.870
50
RandomRandomRandom03/09/2024 07:24:3006/09/2024 13:18:2418:00:0006:00:0077.900
51
RandomRandomRandom03/09/2024 03:20:5606/09/2024 11:24:5518:00:0006:00:0080.070
52
RandomRandomRandom03/09/2024 03:18:1006/09/2024 11:24:2918:00:0006:00:0080.110
53
RandomRandomRandom02/09/2024 16:40:2906/09/2024 11:38:0818:00:0006:00:0090.960
54
RandomRandomRandom05/09/2024 09:45:1406/09/2024 15:00:0818:00:0006:00:0029.250
55
RandomRandomRandom05/09/2024 09:23:5706/09/2024 18:18:0818:00:0006:00:0032.900
56
RandomRandomRandom05/09/2024 09:22:2806/09/2024 18:16:1618:00:0006:00:0032.900
57
RandomRandomRandom05/09/2024 07:32:3406/09/2024 15:00:0818:00:0006:00:0031.460
58
RandomRandomRandom05/09/2024 07:26:1606/09/2024 09:48:1918:00:0006:00:0026.370
59
RandomRandomRandom05/09/2024 07:26:1606/09/2024 09:48:1918:00:0006:00:0026.370
60
RandomRandomRandom05/09/2024 07:26:1606/09/2024 09:48:1918:00:0006:00:0026.370
61
RandomRandomRandom05/09/2024 07:18:5806/09/2024 01:36:2918:00:0006:00:0018.290
62
RandomRandomRandom05/09/2024 04:30:4906/09/2024 01:36:2918:00:0006:00:0021.090
63
RandomRandomRandom05/09/2024 03:52:1406/09/2024 12:38:1618:00:0006:00:0032.770
64
RandomRandomRandom05/09/2024 03:49:0106/09/2024 12:38:0718:00:0006:00:0032.820
65
RandomRandomRandom05/09/2024 03:42:2906/09/2024 15:46:1218:00:0006:00:0036.060
66
RandomRandomRandom05/09/2024 03:41:0006/09/2024 15:16:1518:00:0006:00:0035.590
67
RandomRandomRandom05/09/2024 02:34:4306/09/2024 01:36:2918:00:0006:00:0023.030
68
RandomRandomRandom05/09/2024 02:17:5606/09/2024 15:22:5518:00:0006:00:0037.080
69
RandomRandomRandom05/09/2024 02:15:1506/09/2024 15:22:2318:00:0006:00:0037.120
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
101
102
103
104
105
106