3 Replies Latest reply on Feb 6, 2010 8:16 AM by isaaccs

    The simple but elusive Time Filter

    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?