Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 11 May 2024 22:08:38 +0000

How to Post a Message for Support

Post From: Spreadsheet, formula including all session bars

[2024-03-24 20:11:35]
[Go To First Post]
Sawtooth - Posts: 3995
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)))