Support Board

Date/Time: Fri, 19 Apr 2024 23:07:07 +0000

Post From: SpreadSheets - Referencing 'Last Entry Trade DateTime' (Cell J42)

[2020-01-16 01:47:14] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3975
Would I need to convert the data in J42 into fractime to do this? No. The FRACTIME function removes the date from DateTime value and leaves only the time. If you use FRACTIME, it would be true every day at the time/row where the entry time occurred. can I directly compare the J42 data to the data in Column A? Yes. Use this formula in a Formula Column: =IF(ROW()=3,AND($J$42>A3,$J$42<$J$41),AND($J$42>A3,$J$42<A2)) This will be true in only the row where the day and time of the entry occurred. It will not be true in the row of the same time on another day. Note: Referencing A2 in row 3 will return an error so: If the row equals 3, find J42 between A3 and J41, else find J42 between an earlier row/DateTime and its previous row/DateTime.