Time Diffrence Formula To Exclude Gaps Time Between 5PM - 8AM

Hello everyone,

I need a help with a formula or macro that will display the difference between two dates. But it will not count time between 5pm and 8am.

For example:
Range A2 9/22/14 10:00AM
Range B2 9/23/14 2:00PM

The formula should return 13 hours

I would also need weekends to not be included.

Is this possible with a formula?

Thank you,

-Justin

Hi,

This should yield the result you need, assuming that your start and end dates are within working hours.

=(NETWORKDAYS(A2,B2)-1)*9/24+MOD(B2,1)-MOD(A2,1)


Remember to format your result as [hh]:mm