Background - I'm extracting data from our time keeping db in order to put together a resonably readable payroll report.

 

I have 3 tables I'm working with:

 

punch.employeeid - links to employee.fullname

punch.depthours - accumulated hours worked per punch pair

punch.nonworked - string that states whether vacation, personal or sick time was taken

 

Problem:  punch.depthours includes all worked hours AND non worked hours.  I need a formula that totals the punch.depthours and extracts punch.nonworked hours.  So that all I see is actual hours worked. 

 

Hopefully this makes sense to someone, even reading it myself, it looks very confusing....err.