Login Page - Create Account

Support Board

Date/Time: Wed, 29 Jun 2022 22:05:11 +0000

[User Discussion] - Spreadsheet question, Time values

View Count: 999

[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]
tomgilb - Posts: 3327
Try this:


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]
tomgilb - Posts: 3327
You're correct: The formula in post #2 assumes you do not cross midnight.

To include the dates, try this:


To post a message in this thread, you need to log in with your Sierra Chart account:


Login Page - Create Account