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

user Dionnes said: (!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