Friday, September 14, 2012

yogi_Compute Percentage Of Total Hours Worked For Various Departments

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #748   Sep 14, 2012     www.energyefficientbuild.com.

user Dionnes said: (http://productforums.google.com/forum/?zx=xlo0lp3l8ecl#!category-topic/docs/spreadsheets/Treoi0TQzso)
Percent hours worked... 
Does anyone know what formulas I need to use on Google docs to calculate the percentage hours worked per each department for a 40 hour work week?  
For instance if I work for 
Emergency Room 5 and a half hours 
Pediatrics for 8 hours 
Billing for 26 and a half hours, how do I calculate the percentage hours I worked for each department?
-----------------------------------------------------------------------

following is a solution to the problem

No comments:

Post a Comment