Spreadsheet: 839725d1692187461-how-to-calculate-time-space-as-per-fixed-price-difference-book1
Sheet: Sheet1

Date | Time | open | minute number | price spacing 30
2023-08-16 00:00:00 | 05:00:00 | 29221.6 | 0
2023-08-16 00:00:00 | 05:01:00 | 29222.59 | 1
2023-08-16 00:00:00 | 05:02:00 | 29223.09 | 2
2023-08-16 00:00:00 | 05:03:00 | 29224.07 | 3
2023-08-16 00:00:00 | 05:04:00 | 29227.65 | 4
2023-08-16 00:00:00 | 05:05:00 | 29229.64 | 5
2023-08-16 00:00:00 | 05:06:00 | 29229.01 | 6
2023-08-16 00:00:00 | 05:07:00 | 29225.96 | 7
2023-08-16 00:00:00 | 05:08:00 | 29221.43 | 8
2023-08-16 00:00:00 | 05:09:00 | 29221.72 | 9
2023-08-16 00:00:00 | 05:10:00 | 29222.91 | 10
2023-08-16 00:00:00 | 05:11:00 | 29224.08 | 11
2023-08-16 00:00:00 | 05:12:00 | 29225.82 | 12
2023-08-16 00:00:00 | 05:13:00 | 29224.34 | 13
2023-08-16 00:00:00 | 05:14:00 | 29225.49 | 14
2023-08-16 00:00:00 | 05:15:00 | 29227.1 | 15
2023-08-16 00:00:00 | 05:16:00 | 29226.61 | 16
2023-08-16 00:00:00 | 05:17:00 | 29227.15 | 17
2023-08-16 00:00:00 | 05:18:00 | 29226.85 | 18
2023-08-16 00:00:00 | 05:19:00 | 29227.61 | 19
2023-08-16 00:00:00 | 05:20:00 | 29227.7 | 20
2023-08-16 00:00:00 | 05:21:00 | 29228.39 | 21
2023-08-16 00:00:00 | 05:22:00 | 29226.83 | 22
2023-08-16 00:00:00 | 05:23:00 | 29224.16 | 23
2023-08-16 00:00:00 | 05:24:00 | 29215.79 | 24
2023-08-16 00:00:00 | 05:25:00 | 29213.65 | 25
2023-08-16 00:00:00 | 05:26:00 | 29208.51 | 26
2023-08-16 00:00:00 | 05:27:00 | 29205.71 | 27
2023-08-16 00:00:00 | 05:28:00 | 29205.48 | 28
2023-08-16 00:00:00 | 05:29:00 | 29205.2 | 29
2023-08-16 00:00:00 | 05:30:00 | 29203.93 | 30
2023-08-16 00:00:00 | 05:31:00 | 29199.56 | 31
2023-08-16 00:00:00 | 05:32:00 | 29203.09 | 32
2023-08-16 00:00:00 | 05:33:00 | 29203.09 | 33
2023-08-16 00:00:00 | 05:34:00 | 29202.79 | 34
2023-08-16 00:00:00 | 05:35:00 | 29201.54 | 35
2023-08-16 00:00:00 | 05:36:00 | 29203.13 | 36
2023-08-16 00:00:00 | 05:37:00 | 29204.44 | 37
2023-08-16 00:00:00 | 05:38:00 | 29204.08 | 38
2023-08-16 00:00:00 | 05:39:00 | 29203.57 | 39
2023-08-16 00:00:00 | 05:40:00 | 29203.68 | 40
2023-08-16 00:00:00 | 05:41:00 | 29204.2 | 41
2023-08-16 00:00:00 | 05:42:00 | 29205.1 | 42
2023-08-16 00:00:00 | 05:43:00 | 29205.2 | 43
2023-08-16 00:00:00 | 05:44:00 | 29207.24 | 44
2023-08-16 00:00:00 | 05:45:00 | 29207.05 | 45
2023-08-16 00:00:00 | 05:46:00 | 29206.46 | 46
2023-08-16 00:00:00 | 05:47:00 | 29207.38 | 47
2023-08-16 00:00:00 | 05:48:00 | 29211.19 | 48
2023-08-16 00:00:00 | 05:49:00 | 29214.49 | 49
2023-08-16 00:00:00 | 05:50:00 | 29217.8 | 50
2023-08-16 00:00:00 | 05:51:00 | 29218.5 | 51
2023-08-16 00:00:00 | 05:52:00 | 29218.82 | 52
2023-08-16 00:00:00 | 05:53:00 | 29218.61 | 53
2023-08-16 00:00:00 | 05:54:00 | 29218.64 | 54
2023-08-16 00:00:00 | 05:55:00 | 29217.76 | 55
2023-08-16 00:00:00 | 05:56:00 | 29223.34 | 56
2023-08-16 00:00:00 | 05:57:00 | 29226.37 | 57
2023-08-16 00:00:00 | 05:58:00 | 29226.52 | 58
2023-08-16 00:00:00 | 05:59:00 | 29225.4 | 59
2023-08-16 00:00:00 | 06:00:00 | 29225.06 | 60
2023-08-16 00:00:00 | 06:01:00 | 29224.52 | 61
2023-08-16 00:00:00 | 06:02:00 | 29223.77 | 62
2023-08-16 00:00:00 | 06:03:00 | 29221.64 | 63
2023-08-16 00:00:00 | 06:04:00 | 29221.55 | 64
2023-08-16 00:00:00 | 06:05:00 | 29221.36 | 65
2023-08-16 00:00:00 | 06:06:00 | 29223.12 | 66
2023-08-16 00:00:00 | 06:07:00 | 29224.72 | 67
2023-08-16 00:00:00 | 06:08:00 | 29226.84 | 68
2023-08-16 00:00:00 | 06:09:00 | 29224.69 | 69
2023-08-16 00:00:00 | 06:10:00 | 29223.2 | 70
2023-08-16 00:00:00 | 06:11:00 | 29222.31 | 71
2023-08-16 00:00:00 | 06:12:00 | 29222.31 | 72
2023-08-16 00:00:00 | 06:13:00 | 29222.67 | 73
2023-08-16 00:00:00 | 06:14:00 | 29221.5 | 74
2023-08-16 00:00:00 | 06:15:00 | 29218.38 | 75
2023-08-16 00:00:00 | 06:16:00 | 29214.11 | 76
2023-08-16 00:00:00 | 06:17:00 | 29214.61 | 77
2023-08-16 00:00:00 | 06:18:00 | 29213 | 78
2023-08-16 00:00:00 | 06:19:00 | 29213.57 | 79
2023-08-16 00:00:00 | 06:20:00 | 29213.63 | 80
2023-08-16 00:00:00 | 06:21:00 | 29213.3 | 81
2023-08-16 00:00:00 | 06:22:00 | 29211.58 | 82
2023-08-16 00:00:00 | 06:23:00 | 29210.03 | 83
2023-08-16 00:00:00 | 06:24:00 | 29210.54 | 84
2023-08-16 00:00:00 | 06:25:00 | 29210 | 85
2023-08-16 00:00:00 | 06:26:00 | 29209.75 | 86
2023-08-16 00:00:00 | 06:27:00 | 29208.5 | 87
2023-08-16 00:00:00 | 06:28:00 | 29202.1 | 88
2023-08-16 00:00:00 | 06:29:00 | 29199.86 | 89
2023-08-16 00:00:00 | 06:30:00 | 29199.93 | 90
2023-08-16 00:00:00 | 06:31:00 | 29198.79 | 91
2023-08-16 00:00:00 | 06:32:00 | 29198.77 | 92
2023-08-16 00:00:00 | 06:33:00 | 29200.64 | 93
2023-08-16 00:00:00 | 06:34:00 | 29200.95 | 94
2023-08-16 00:00:00 | 06:35:00 | 29200.5 | 95
2023-08-16 00:00:00 | 06:36:00 | 29203.34 | 96
2023-08-16 00:00:00 | 06:37:00 | 29203.77 | 97
2023-08-16 00:00:00 | 06:38:00 | 29203.19 | 98
2023-08-16 00:00:00 | 06:39:00 | 29205.09 | 99
2023-08-16 00:00:00 | 06:40:00 | 29206.77 | 100
2023-08-16 00:00:00 | 06:41:00 | 29210.91 | 101
2023-08-16 00:00:00 | 06:42:00 | 29211.43 | 102
2023-08-16 00:00:00 | 06:43:00 | 29210.95 | 103
2023-08-16 00:00:00 | 06:44:00 | 29210.51 | 104
2023-08-16 00:00:00 | 06:45:00 | 29210.49 | 105
2023-08-16 00:00:00 | 06:46:00 | 29210.76 | 106
2023-08-16 00:00:00 | 06:47:00 | 29213.39 | 107
2023-08-16 00:00:00 | 06:48:00 | 29213.91 | 108
2023-08-16 00:00:00 | 06:49:00 | 29212.29 | 109
2023-08-16 00:00:00 | 06:50:00 | 29212.55 | 110
2023-08-16 00:00:00 | 06:51:00 | 29212.35 | 111
2023-08-16 00:00:00 | 06:52:00 | 29212.12 | 112
2023-08-16 00:00:00 | 06:53:00 | 29212.12 | 113
2023-08-16 00:00:00 | 06:54:00 | 29211.77 | 114
2023-08-16 00:00:00 | 06:55:00 | 29204.52 | 115
2023-08-16 00:00:00 | 06:56:00 | 29202.44 | 116
2023-08-16 00:00:00 | 06:57:00 | 29200.84 | 117
2023-08-16 00:00:00 | 06:58:00 | 29201.06 | 118
2023-08-16 00:00:00 | 06:59:00 | 29200.83 | 119
2023-08-16 00:00:00 | 07:00:00 | 29199.09 | 120
2023-08-16 00:00:00 | 07:01:00 | 29200.94 | 121
2023-08-16 00:00:00 | 07:02:00 | 29200.96 | 122
2023-08-16 00:00:00 | 07:03:00 | 29200.34 | 123
2023-08-16 00:00:00 | 07:04:00 | 29201.45 | 124
2023-08-16 00:00:00 | 07:05:00 | 29201.45 | 125
2023-08-16 00:00:00 | 07:06:00 | 29201.92 | 126
2023-08-16 00:00:00 | 07:07:00 | 29201.95 | 127
2023-08-16 00:00:00 | 07:08:00 | 29202.52 | 128
2023-08-16 00:00:00 | 07:09:00 | 29202.76 | 129
2023-08-16 00:00:00 | 07:10:00 | 29203.65 | 130
2023-08-16 00:00:00 | 07:11:00 | 29203.13 | 131
2023-08-16 00:00:00 | 07:12:00 | 29202.44 | 132
2023-08-16 00:00:00 | 07:13:00 | 29202.44 | 133
2023-08-16 00:00:00 | 07:14:00 | 29202.57 | 134
2023-08-16 00:00:00 | 07:15:00 | 29202.54 | 135
2023-08-16 00:00:00 | 07:16:00 | 29202.24 | 136
2023-08-16 00:00:00 | 07:17:00 | 29201.54 | 137
2023-08-16 00:00:00 | 07:18:00 | 29201.19 | 138
2023-08-16 00:00:00 | 07:19:00 | 29201.04 | 139
2023-08-16 00:00:00 | 07:20:00 | 29199.72 | 140
2023-08-16 00:00:00 | 07:21:00 | 29200.74 | 141
2023-08-16 00:00:00 | 07:22:00 | 29200.46 | 142
2023-08-16 00:00:00 | 07:23:00 | 29200.67 | 143
2023-08-16 00:00:00 | 07:24:00 | 29199.73 | 144
2023-08-16 00:00:00 | 07:25:00 | 29198.98 | 145
2023-08-16 00:00:00 | 07:26:00 | 29199.09 | 146
2023-08-16 00:00:00 | 07:27:00 | 29198.53 | 147
2023-08-16 00:00:00 | 07:28:00 | 29198.57 | 148
2023-08-16 00:00:00 | 07:29:00 | 29197.08 | 149
2023-08-16 00:00:00 | 07:30:00 | 29195.08 | 150
2023-08-16 00:00:00 | 07:31:00 | 29194.48 | 151
2023-08-16 00:00:00 | 07:32:00 | 29193.48 | 152
2023-08-16 00:00:00 | 07:33:00 | 29193.23 | 153
2023-08-16 00:00:00 | 07:34:00 | 29193.04 | 154
2023-08-16 00:00:00 | 07:35:00 | 29192.26 | 155
2023-08-16 00:00:00 | 07:36:00 | 29189.73 | 156
2023-08-16 00:00:00 | 07:37:00 | 29188.89 | 157
2023-08-16 00:00:00 | 07:38:00 | 29187.6 | 158
2023-08-16 00:00:00 | 07:39:00 | 29189.39 | 159
2023-08-16 00:00:00 | 07:40:00 | 29191.46 | 160
2023-08-16 00:00:00 | 07:41:00 | 29191.26 | 161
2023-08-16 00:00:00 | 07:42:00 | 29192.51 | 162
2023-08-16 00:00:00 | 07:43:00 | 29193.85 | 163
2023-08-16 00:00:00 | 07:44:00 | 29193.59 | 164
2023-08-16 00:00:00 | 07:45:00 | 29193.59 | 165
2023-08-16 00:00:00 | 07:46:00 | 29187.9 | 166
2023-08-16 00:00:00 | 07:47:00 | 29184 | 167
2023-08-16 00:00:00 | 07:48:00 | 29184.27 | 168
2023-08-16 00:00:00 | 07:49:00 | 29183.49 | 169
2023-08-16 00:00:00 | 07:50:00 | 29184.75 | 170
2023-08-16 00:00:00 | 07:51:00 | 29185.32 | 171
2023-08-16 00:00:00 | 07:52:00 | 29181.36 | 172
2023-08-16 00:00:00 | 07:53:00 | 29180.62 | 173
2023-08-16 00:00:00 | 07:54:00 | 29182.25 | 174
2023-08-16 00:00:00 | 07:55:00 | 29185.36 | 175
2023-08-16 00:00:00 | 07:56:00 | 29188.86 | 176
2023-08-16 00:00:00 | 07:57:00 | 29185.54 | 177
2023-08-16 00:00:00 | 07:58:00 | 29184.17 | 178
2023-08-16 00:00:00 | 07:59:00 | 29183.86 | 179
2023-08-16 00:00:00 | 08:00:00 | 29182.11 | 180
2023-08-16 00:00:00 | 08:01:00 | 29180.57 | 181
2023-08-16 00:00:00 | 08:02:00 | 29179.66 | 182
2023-08-16 00:00:00 | 08:03:00 | 29179.25 | 183
2023-08-16 00:00:00 | 08:04:00 | 29175.72 | 184
2023-08-16 00:00:00 | 08:05:00 | 29176.36 | 185
2023-08-16 00:00:00 | 08:06:00 | 29174.07 | 186
2023-08-16 00:00:00 | 08:07:00 | 29174.13 | 187
2023-08-16 00:00:00 | 08:08:00 | 29173.8 | 188
2023-08-16 00:00:00 | 08:09:00 | 29176.33 | 189
2023-08-16 00:00:00 | 08:10:00 | 29176.36 | 190
2023-08-16 00:00:00 | 08:11:00 | 29176.36 | 191
2023-08-16 00:00:00 | 08:12:00 | 29177.75 | 192
2023-08-16 00:00:00 | 08:13:00 | 29177.5 | 193
2023-08-16 00:00:00 | 08:14:00 | 29177.75 | 194
2023-08-16 00:00:00 | 08:15:00 | 29177.58 | 195
2023-08-16 00:00:00 | 08:16:00 | 29177.6 | 196
2023-08-16 00:00:00 | 08:17:00 | 29177.3 | 197
2023-08-16 00:00:00 | 08:18:00 | 29175.91 | 198
2023-08-16 00:00:00 | 08:19:00 | 29175.2 | 199
2023-08-16 00:00:00 | 08:20:00 | 29174.04 | 200
2023-08-16 00:00:00 | 08:21:00 | 29172.67 | 201
2023-08-16 00:00:00 | 08:22:00 | 29169.33 | 202
2023-08-16 00:00:00 | 08:23:00 | 29167.42 | 203
2023-08-16 00:00:00 | 08:24:00 | 29162.93 | 204
2023-08-16 00:00:00 | 08:25:00 | 29160.68 | 205
2023-08-16 00:00:00 | 08:26:00 | 29164.94 | 206
2023-08-16 00:00:00 | 08:27:00 | 29170.58 | 207
2023-08-16 00:00:00 | 08:28:00 | 29167.84 | 208
2023-08-16 00:00:00 | 08:29:00 | 29166.31 | 209
2023-08-16 00:00:00 | 08:30:00 | 29165.93 | 210
2023-08-16 00:00:00 | 08:31:00 | 29163.7 | 211
2023-08-16 00:00:00 | 08:32:00 | 29162.26 | 212
2023-08-16 00:00:00 | 08:33:00 | 29160.24 | 213
2023-08-16 00:00:00 | 08:34:00 | 29161.33 | 214
2023-08-16 00:00:00 | 08:35:00 | 29160 | 215
2023-08-16 00:00:00 | 08:36:00 | 29157.56 | 216
2023-08-16 00:00:00 | 08:37:00 | 29138.88 | 217
2023-08-16 00:00:00 | 08:38:00 | 29144.75 | 218
2023-08-16 00:00:00 | 08:39:00 | 29138.85 | 219
2023-08-16 00:00:00 | 08:40:00 | 29139.39 | 220
2023-08-16 00:00:00 | 08:41:00 | 29134.31 | 221
2023-08-16 00:00:00 | 08:42:00 | 29139.36 | 222
2023-08-16 00:00:00 | 08:43:00 | 29135.14 | 223
2023-08-16 00:00:00 | 08:44:00 | 29133.98 | 224
2023-08-16 00:00:00 | 08:45:00 | 29130.72 | 225
2023-08-16 00:00:00 | 08:46:00 | 29129.1 | 226
2023-08-16 00:00:00 | 08:47:00 | 29123.53 | 227
2023-08-16 00:00:00 | 08:48:00 | 29132.04 | 228
2023-08-16 00:00:00 | 08:49:00 | 29128.74 | 229
2023-08-16 00:00:00 | 08:50:00 | 29129.31 | 230
2023-08-16 00:00:00 | 08:51:00 | 29129.71 | 231
2023-08-16 00:00:00 | 08:52:00 | 29127.43 | 232
2023-08-16 00:00:00 | 08:53:00 | 29120.79 | 233
2023-08-16 00:00:00 | 08:54:00 | 29131.92 | 234
2023-08-16 00:00:00 | 08:55:00 | 29130.87 | 235
2023-08-16 00:00:00 | 08:56:00 | 29132.33 | 236
2023-08-16 00:00:00 | 08:57:00 | 29133.98 | 237
2023-08-16 00:00:00 | 08:58:00 | 29125.92 | 238
2023-08-16 00:00:00 | 08:59:00 | 29120.21 | 239
2023-08-16 00:00:00 | 09:00:00 | 29118.78 | 240
2023-08-16 00:00:00 | 09:01:00 | 29124.05 | 241
2023-08-16 00:00:00 | 09:02:00 | 29124.25 | 242
2023-08-16 00:00:00 | 09:03:00 | 29122.99 | 243
2023-08-16 00:00:00 | 09:04:00 | 29118.66 | 244
2023-08-16 00:00:00 | 09:05:00 | 29114.36 | 245
2023-08-16 00:00:00 | 09:06:00 | 29111.62 | 246
2023-08-16 00:00:00 | 09:07:00 | 29110.49 | 247
2023-08-16 00:00:00 | 09:08:00 | 29104.92 | 248
2023-08-16 00:00:00 | 09:09:00 | 29103.21 | 249
2023-08-16 00:00:00 | 09:10:00 | 29099.31 | 250
2023-08-16 00:00:00 | 09:11:00 | 29105.04 | 251
2023-08-16 00:00:00 | 09:12:00 | 29106.3 | 252
2023-08-16 00:00:00 | 09:13:00 | 29107.39 | 253
2023-08-16 00:00:00 | 09:14:00 | 29108.86 | 254
2023-08-16 00:00:00 | 09:15:00 | 29112 | 255
2023-08-16 00:00:00 | 09:16:00 | 29117.31 | 256
2023-08-16 00:00:00 | 09:17:00 | 29127.25 | 257
2023-08-16 00:00:00 | 09:18:00 | 29132.67 | 258
2023-08-16 00:00:00 | 09:19:00 | 29137.91 | 259
2023-08-16 00:00:00 | 09:20:00 | 29145.89 | 260
2023-08-16 00:00:00 | 09:21:00 | 29144.25 | 261
2023-08-16 00:00:00 | 09:22:00 | 29142.16 | 262
2023-08-16 00:00:00 | 09:23:00 | 29141.49 | 263
2023-08-16 00:00:00 | 09:24:00 | 29134.38 | 264
2023-08-16 00:00:00 | 09:25:00 | 29142.68 | 265
2023-08-16 00:00:00 | 09:26:00 | 29140.54 | 266
2023-08-16 00:00:00 | 09:27:00 | 29136.52 | 267
2023-08-16 00:00:00 | 09:28:00 | 29137.06 | 268
2023-08-16 00:00:00 | 09:29:00 | 29134.6 | 269
2023-08-16 00:00:00 | 09:30:00 | 29136.16 | 270
2023-08-16 00:00:00 | 09:31:00 | 29137.26 | 271
2023-08-16 00:00:00 | 09:32:00 | 29137.7 | 272
2023-08-16 00:00:00 | 09:33:00 | 29144.38 | 273
2023-08-16 00:00:00 | 09:34:00 | 29145.12 | 274
2023-08-16 00:00:00 | 09:35:00 | 29145.75 | 275
2023-08-16 00:00:00 | 09:36:00 | 29147.4 | 276
2023-08-16 00:00:00 | 09:37:00 | 29149.08 | 277
2023-08-16 00:00:00 | 09:38:00 | 29151.16 | 278
2023-08-16 00:00:00 | 09:39:00 | 29153.01 | 279
2023-08-16 00:00:00 | 09:40:00 | 29162.29 | 280
2023-08-16 00:00:00 | 09:41:00 | 29161.74 | 281