Sign in with
Sign up | Sign in
Your question

Comparision of work as per week

Last response: in Applications
Share
July 11, 2012 7:21:40 AM

I want to make a Excel sheet in which i have to show the Total Standard time for any task and then will also put Total real time taken for the same task in which i have to also show the comparison percentage like Extra time or below the time line.

More about : comparision work week

July 11, 2012 1:51:49 PM

This topic has been moved from the section Windows XP to section Applications by Area51reopened
m
0
l
July 19, 2012 5:52:23 PM

Use math. Setup a formula that uses the two cells with the two times you enter to calculate the third cell. Excel help file will show you how to do that. If you are setting this up, you should know how to get a % from the two numbers already.

You can then use conditional formatting in the cell to color it or do something else to show if the actual time was greater or lesser than estimated.
m
0
l
Related resources
!