Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Sat, 01 Feb 2025 14:59:09 +0000

[Programming Help] - how to get column value X in selected time to column Z

View Count: 716

[Page 1 of 1] First Page -- 1 -- Last Page

[2019-07-18 11:09:02] #1 [Go To First Post]
User865284 - Posts: 4
Good day I need help to SpreadsheetStudy ??? how to get column value X in selected time to column Z thank you
0x Thank you
001.png / V - Attached On 2019-07-18 10:54:50 UTC - Size: 45.5 KB - 227 views

[2019-07-18 13:31:11] #2 [Go To First Post]
Sawtooth - Posts: 4164
Try this formula in Z3: =IF(MROUND(FRACTIME(A3),1/86400)=TIMEVALUE("08:30:00"),X3,Z4) FRACTIME gets the Time value from the DateTime in A3. MROUND rounds it to the nearest 1 second (there are 86400 seconds in 24 hours) This is necessary to remove floating point errors. TIMEVALUE converts text of the Time value into Serial DateTime format. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MROUND_Function https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#FRACTIME_Function https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#TIMEVALUE_Function
1x Thank you

[Page 1 of 1] First Page -- 1 -- Last Page