Calculate % divide by a fixed monthly number

[GeorgesKV]

Hi all,

So I have two columns as stated in the picture above, where I have a date and worked hours, the date repeats since you don't usually work 8 hours in one thing only. What I need is to achieve this chart (image below) so for the bars it's okay, I've already calculated billable hours, but now I don't know how to calculate the % based on what should be a month time of work (160 hours w/o holidays) to create the lines.  In excel I would just create a row that "=(A row with the monthly sum of hours)/160"

User Date Billable Hours

Employee A	2018-10-12	Yes	4
Employee A	2018-10-12	No	3
Employee A	2018-10-12	No	1
Employee A	2018-10-13	Yes	2