Im building a new holiday request system for our company in Knack, but having trouble trying to figure out the best way to calculate the time properly.
So here's the challenge.
Have a date field (Timer based) where someone selects a date range as to when they want to take off. So say for example Bob puts in a date range of the 1st March (8am) to 3rd March (10pm) - I just want to calculate the amount of business hours that needs to be deducted from their entitlement.
Open to suggestions if there is a better way to do this - but appreciate any help!