Calculating a percentage

[Deano478]

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

[ShankerV · Accepted solution]

Hi @Deano478 

Please find the expected output.

[ShankerV · Accepted solution]

Hi @Deano478 

Please find one more way to do it if need to summarize same names in same type.

Many thanks

Shanker V