I would’ve thought this one to be so simple but yet i am pulling my hair out. This is nothing like a spreadsheet…
I need a virtual column to determine wether a time (set via a time picker on my form) is less than (or greater than) a set time (10:30am) and change it’s own value to either 0 or 1 accordingly. This would be a trigger to deduct 15mins from a work day.
In total, I actually need to determine wether a time frame crosses a break of 15mins which starts at 10:30am (and then lunch and afternoon tea)
Any ideas or samples would be greatly appreciated.
Thanks in advance