I have created a calculated field in a pivot table to show the difference between "contracted hours" and "average hours actually worked" but all the results show zero. The calculated field is based on ='Contract Hours'-'Total Hours' (I have tried the sum the other way around as well and still zero) and the column is formatted to Time. Does anyone know what I am missing please?
Sum of Contract Hours | Average of Total Hours Worked | Sum of Difference in hours worked |
0:00:00 | 0:00:00 | |
0:00:00 | 1:45:00 | 0:00:00 |
0:00:00 | 0:00:00 | |
0:00:00 | 3:49:40 | 0:00:00 |
0:00:00 | 3:29:00 | 0:00:00 |
0:00:00 | 0:00:00 | |
0:00:00 | 1:45:00 | 0:00:00 |
0:00:00 | 6:15:00 | 0:00:00 |
0:00:00 | 27:30:00 | 0:00:00 |