Re^2: determining work hours between 2 dates

[tokpela]

in reply to Re: determining work hours between 2 dates
in thread determining work hours between 2 dates

>> The 2 dates have a time component as well, so the first day
>> can start any time and the end date too. So, I will need to
>> calculate the HH:MM:SS for the first and last days as well.

That's actually already taken into account in my test script above.
It does the calculations in seconds and then converts to hours.

The hard part for you may be dealing with holidays.