Progressive Analysis

[elkahira]

Hi everyone and thanks in advance for trying to help me

So, to explain what I need, I'm gonna tell you the scenario.

I work for a communications company solving client problems.

I work with a daily objective, that goes between solving 22 problems a day, up to 26.

The average being 24, in 8 hours work I must resolve 3 problems/hour.

I already configured my Worksheet to give me the average of the day/month/year, how many problems am I away from the average and even how does the number of resolutions I have at the moment influences the average of the current month.

What I need is:

I wanted my file to be able to see what time is it, from there calculate how many hours I've worked and, in average, how many problems I should have solved vs the one I did actually solve.

This meaning, in real time, I would always know if I was behind schedule, up to it or even in advance.

Is it possible?

Thanks again

[etaf]

you could use NOW()

work out your hourly rate

so you could have in cell A2 your starttime
then in B2 = now
then this will work out the fraction of time passed
=(TIME(HOUR(B2),MINUTE(B2),0) - TIME(HOUR(A2),MINUTE(A2),0))*24
as a number - format the cell as general or number

then divide your goal by that number
will give you how many you should have achieved so far

or

take that away from your total hours , and how many you have completed from you total number- will calculate how many per hour you need to do

you could also conditional format to see if ahead or behind time

[elkahira]

Thanks a lot mate.

=(TIME(HOUR(B2),MINUTE(B2),0) - TIME(HOUR(A2),MINUTE(A2),0))*24

Worked great for what I wanted.

Reputation to you sir.

[etaf]

your welcome

[etaf]

actually here is a simpler formula

=(MOD(B2-A2,1))*24