Hi all,
I'm trying to calculate the percentage of time not entered for each person both monthly and daily I know I'll probably need to use a summarise and formula tool in tandem to accomplish this task but I'm not to sure how to set them up.
Any assistance with this would be greatly appreciated
The sample data looks like this:
| Type | Name | Time Entered | Time Not Entered | Target Total Time |
| Daily | John | 27 | 9.25 | 36.25 |
| Monthly | James | 11.75 | 24.5 | 36.25 |
| Monthly | James | 31.8 | 4.45 | 36.25 |
| Daily | Tony | 13.2 | 23.05 | 36.25 |
| Daily | Tim | 22.25 | 14 | 36.25 |
| Monthly | Tony | 26.25 | 10 | 36.25 |
| Daily | Tim | 5.25 | 31 | 36.25 |
| Daily | James | 35.75 | 0.5 | 36.25 |
| Monthly | Tim | 27.7 | 8.55 | 36.25 |
| Monthly | John | 21 | 16.25 | 36.25 |
