G
Guest
I need to determine a % of events based on the number of days an individual
has worked. My spreadsheet is set up by the week and QTD & YTD totals. The
% needs to be calculated each quarter and a total % for the year. I'm not
sure how to start. I had it set with SUM(D315)/65. That works as long as
each wk is completed. If not, the calculation is wrong. Is there calculate
days based on weeks completed?
has worked. My spreadsheet is set up by the week and QTD & YTD totals. The
% needs to be calculated each quarter and a total % for the year. I'm not
sure how to start. I had it set with SUM(D315)/65. That works as long as
each wk is completed. If not, the calculation is wrong. Is there calculate
days based on weeks completed?