AnsweredAssumed Answered

The simple but elusive Time Filter

Question asked by isaaccs on Feb 4, 2010
Latest reply on Feb 6, 2010 by isaaccs

Title

The simple but elusive Time Filter

Post

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:

 

filterStartTime

filterEndTime

startTime

endTime 

 

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? 

 

 

Outcomes