Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to calculate productivity over hours spent
I have a data like below, where i am calculating productivity on daily basis
for all employees and am spending more tiime on this. Please help me, is there any formula to calculate productivity per hour. Emp Production HrsWorked Productivity p/hr A 7000 13:15 ? B 6500 11:10 ? C 6800 12:30 ? D 7100 10:58 ? Thanks in advance. Balaji |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to calculate productivity over hours spent
The "trick" knowing that Excel stores time as a fraction of a day
So if the first set of data is in row 2 then =B2/C2 will give the wrong answer while =B2/(C2*24) will give the correct answer. However, Excel might be over helpful and format this a time, so use the Format Painter to copy B2's format to D2; or just format the cell with the Format dialog. Now you can copy the formula down the column best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Balaji" wrote in message ... I have a data like below, where i am calculating productivity on daily basis for all employees and am spending more tiime on this. Please help me, is there any formula to calculate productivity per hour. Emp Production HrsWorked Productivity p/hr A 7000 13:15 ? B 6500 11:10 ? C 6800 12:30 ? D 7100 10:58 ? Thanks in advance. Balaji |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to calculate productivity over hours spent
If by 13:15 you mean 13 hours, 15 minutes, then:
=B1/(24*C1) should display 528.30 -- Gary''s Student - gsnu200860 "Balaji" wrote: I have a data like below, where i am calculating productivity on daily basis for all employees and am spending more tiime on this. Please help me, is there any formula to calculate productivity per hour. Emp Production HrsWorked Productivity p/hr A 7000 13:15 ? B 6500 11:10 ? C 6800 12:30 ? D 7100 10:58 ? Thanks in advance. Balaji |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to calculate productivity over hours spent
Thank you so much for your help, It is really helpful to me to avoid earlier
my manual calculations. Once again thank you. Balaji "Gary''s Student" wrote: If by 13:15 you mean 13 hours, 15 minutes, then: =B1/(24*C1) should display 528.30 -- Gary''s Student - gsnu200860 "Balaji" wrote: I have a data like below, where i am calculating productivity on daily basis for all employees and am spending more tiime on this. Please help me, is there any formula to calculate productivity per hour. Emp Production HrsWorked Productivity p/hr A 7000 13:15 ? B 6500 11:10 ? C 6800 12:30 ? D 7100 10:58 ? Thanks in advance. Balaji |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to calculate productivity over hours spent
Thank you so much for help. This is really helpful to me to avoid my manual
calculations now itself. Once again Thank you. Balaji "Bernard Liengme" wrote: The "trick" knowing that Excel stores time as a fraction of a day So if the first set of data is in row 2 then =B2/C2 will give the wrong answer while =B2/(C2*24) will give the correct answer. However, Excel might be over helpful and format this a time, so use the Format Painter to copy B2's format to D2; or just format the cell with the Format dialog. Now you can copy the formula down the column best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Balaji" wrote in message ... I have a data like below, where i am calculating productivity on daily basis for all employees and am spending more tiime on this. Please help me, is there any formula to calculate productivity per hour. Emp Production HrsWorked Productivity p/hr A 7000 13:15 ? B 6500 11:10 ? C 6800 12:30 ? D 7100 10:58 ? Thanks in advance. Balaji |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting hours spent by a team per project | Excel Discussion (Misc queries) | |||
Calculating hours spent per team | Excel Discussion (Misc queries) | |||
summing up hours spent on jobs | Excel Discussion (Misc queries) | |||
how do I calculate hours spent x an hourly rate? | Excel Worksheet Functions | |||
How do I calculate the hours spent on a project by entering a sta. | Excel Worksheet Functions |