I'm trying to create a macro that will tell me the number of hours between two date/time fields. I need it to only count the hours between 7am and 5pm Monday Thru Friday. Is that possible? Here is an example of what I'm looking for:

Col A : 16 March 2014 8:00am ( 16 March is a Friday)
Col B : 19 March 2014 8:30am ( 19 March is a Monday)

The answer should be 10.5 hours. 9 hours on March 16 and 1.5 hours on Monday March 19.

I've looked into Weekday and Networkdays function but I think I need something else to get the hours.