Hi,

I thought I would find plenty of help for this around the web and in these forums, but alas, I have not.

What I need to do is calculate the number of hours between two times, but only within a set 13 hour business day. 8am-9pm 7 days a week.

I have used networkdays before, but that excludes weekends.

For example, Monday 8am till Thursday 11pm, calculate the number of hourse and minutes. BUT exclude each night's hours between 9pm-8am.

Hope that makes sense!

Thanks for ANY help.

narelle.