Calculate difference in values for different dates

Copper Contributor

Employees work different total hours per pay period.  An employee may increase or decrease their total number of hours worked.  The start (and end) dates of when the hours are changed can vary by person so there is not a consistent start or duration of time.

I would like to find a way to calculate the change in total hours for every change in date.  Keeping in mind that for any given period of time (for last 2 years for example) an employee may have 0, 1, or multiple changes.

 

(Goal of project is to determine volume of changes - specifically decreases- in the total hours worked by person and department over last 2 years)

0 Replies