LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting hours spent by a team per project The Fool on the Hill Excel Discussion (Misc queries) 3 May 28th 09 11:14 AM
Calculating hours spent per team The Fool on the Hill Excel Discussion (Misc queries) 1 December 29th 08 02:37 PM
summing up hours spent on jobs kayti57 Excel Discussion (Misc queries) 2 November 29th 06 05:51 AM
how do I calculate hours spent x an hourly rate? JC Excel Worksheet Functions 2 January 5th 06 04:32 PM
How do I calculate the hours spent on a project by entering a sta. joeh Excel Worksheet Functions 4 November 2nd 04 06:39 PM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"