Support Board
Date/Time: Sat, 01 Feb 2025 15:02:03 +0000
Post From: how to get column value X in selected time to column Z
| [2019-07-18 13:31:11] |
| 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 |