Support Board
Date/Time: Mon, 25 Nov 2024 07:47:23 +0000
Post From: Spreadsheet, formula including all session bars
| [2024-03-24 20:11:35] |
| Sawtooth - Posts: 4120 |
|
This is the basic idea to limit display to session times: =AND(FRACTIME(A3)>=TIME(9,30,0),FRACTIME(A3)<TIME(16,00,0)) You could put this in a spare Formula Column, e.g. AR3, and reference that column in each of your line formulas, like this: =IF(AND(AQ3=1,AR3=1),(ID2.SG13@3-((ID2.SG13@3-ID2.SG3@3)*0.236)),(ID2.SG13@3-((ID2.SG13@3-L3)*0.236))) |