I have a similar requirement in the application I manage. There I have the added complexity that work hours are not necessarily the same for all employees (part-timers, weekend duty, ...), weekends don't fall on the same days in all countries (eg. Middle East), holidays are not the same in all countries, etc ...
Just wanted to mention this, in case you overlooked.
Comment on Re: determining work hours between 2 dates
Thanks for all the input people!
I am going to give it a try with the Date::Calendar module using the delta_workdays method. It handles holidays, etc.
If I get it to work I will post however I have done it here for scrutiny from you all :)
Kosie