Support Board
Date/Time: Mon, 25 Nov 2024 04:43:41 +0000
[User Discussion] - Spreadsheet question, Time values
View Count: 1541
| [2014-01-13 17:55:12] |
| sbsierra - Posts: 71 |
|
I wanted to disable Auto Trading via cell J28, when the last trade via cell J42 ist less than n-minutes ago. I don´t know how to use a formula to convert time to absolute minutes. Thanks for help. |
| [2014-01-13 18:27:36] |
| Sawtooth - Posts: 4120 |
|
Try this: =(J41-INT(J41))-(J42-INT(J42))<TIMEVALUE("00:05:00") This removes the dates from the date-times, finds the difference, and compares it to the Excel timevalue of 5 minutes. |
| [2014-01-13 22:23:00] |
| sbsierra - Posts: 71 |
|
thank you. but this will only work if I the time of the last trade is bigger than the current time. is there any way to get the difference with the date?
|
| [2014-01-13 23:11:26] |
| Sawtooth - Posts: 4120 |
|
You're correct: The formula in post #2 assumes you do not cross midnight. To include the dates, try this: =J41-J42<TIMEVALUE("00:05:00") |
To post a message in this thread, you need to log in with your Sierra Chart account: