How to determine hours worked on a date in a date range assuming 8 hours per day, no w\e

Hi all! I am building a resource sheet that consumes information from a task sheet, and I want the resource sheet to show day by day what hours fractions of hours were worked each day. Assumptions are the resource works full time, 8:00 AM - 4:00 PM (8 hours, lunch break is not accounted for) and not weekends.

Attached is the task and resource sheet sample.

tasks.pngRESOURCES.png

How can I do this with a formula in the highlighted cells in 'Resource'? For example, I'd expect the formula to calculate '4.8' in cell F4, as on 2/9/15 the 'Consultant' is expected to work from 11:12 AM - 4:00 PM. I'd like to avoid using VBA, pivot tables and iterative calculation if possible

Any help much appreciated

Neil