Support Board
Date/Time: Fri, 19 Dec 2025 22:13:06 +0000
Post From: Spreadsheet study: Direct A3 result alignment between two sheets
| [2020-10-13 11:48:39] |
| Sawtooth - Posts: 4300 |
|
If I understand you correctly, this might work for you: =FLOOR(A3,15/1440) This will return the DateTime of the 15min bar corresponding to each of the 1TickRange bars. |