Finding billable hours
I've got a database that keeps track of client jobs, employee hours (including sick time and hours working on jobs), and a few other things. I need to display the percent of time spent weekly by an employee working on client jobs. There are a specific number of non-billable job numbers set aside for for employees to log sick time, vacation time, etc. So I need to find out how to get the total number of hours spent working on billable jobs over the total hours worked in any specific week. Hopefully the description makes sense.