target calculation

I've been off work a while and I just want to make sure I'm doing it properly. Goal call hold time is 300 seconds but actual is 660 seconds. I want to calculate progress toward goal of 300 seconds as a percentage. I have 45% as the achievement toward that goal...is that correct? Note: in the...

Hi, I have a table range to 30 columns and 100 rows with some blank cells in it. The cells values are 6 , 8 , 10 , SL , VC and RE other than the blanks. Lets suppose the current sum of table range mentioned above is 6000. I need a VBA code that will target the cells with numerical values only...

Hi, I have the yearly turnover target for a company and would like to calculate the monthly, weekly and daily targets to meet the yearly. I want to be able to put the actual daily revenue and automatically recalculate the next day target and the next month target. For example if my yearly...

Below is a sample table i'm working on. We have an opening number for each member in B and a target closing number in C. Column D is the actual closing number. e.g. Mem5 target is 17,000 and closing is 17,000, Column E should show 100%. Mem4 target is 18,400, but opening and closing are same at...