Support Board
Date/Time: Wed, 05 Feb 2025 09:39:53 +0000
HOUR(A4) returns #NUM!
View Count: 953
[2014-12-03 12:16:07] |
namlem - Posts: 94 |
Hello, today i started my chartbooks and found that all formulas showing #NUM!. I did a simple test and found out that hour(a4) return #NUM!. What can be the reason for that? I didn't change anything in my formulas for few weeks already. instrument XAUUSD Date Time Of Last Edit: 2014-12-03 12:16:38
|
Private File |
[2014-12-03 18:37:27] |
Sierra Chart Engineering - Posts: 104368 |
We have tested this using Old Spreadsheets and when we use this formula: =HOUR(A4) We get 13 with this value: 2014-12-03 13:33 We are not sure what the problem is in your case. We are not able to resolve any problems with Old Spreadsheets. We do not have the source code and all of our development is with New Spreadsheets now. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: