The simple but elusive Time Filter
Hi. This seems simple enough but I can't figure it and at this point fear I'm over thinking it.
I'm seeking a function or calculation (explained) that, given:
returns the quantity of hours/time present between the start time and the end time within the filter range.
So, for example, in a timesheet, we are only looking for 'overtime' hours worked between 1 am and 6 am...
filterStartTime = 1:00am
filterEndTime = 6:00am
employeeStartTime = 12:30am
employeeEndTime = 11:00am
This function would return 5 hours (the time between the filter values).
Any thoughts/functions/insights that anyone has used?