I need some assistance writing two calculations:
In an entry I have two separate date/time fields. One for start date and time, and one for end date and time.
What I'm trying to accomplish is the calculation of time based on if the time is inside a standard time range or outside a standard time range.
IE: Time range is 7:30am - 4:30pm
start date time: 12/1/2015 2:30 pm
end date time: 12/1/2015 8:00pm
Calculation 1 is for the sum of time that falls within the range = 2
Calculation 2 is for the sum of time that falls outside the range = 3.5
Is this possible?
Please sign in to leave a comment.