This is exactly what we're looking for.... was there an answer?

"Inquiring Exceler" wrote:

Does anyone know how you would calculate work days in hrs. So if the work day
is from 8am to 5pm and I want to calculate to number of hours between 2
dates. Any assistance on this would be appreciated.

"Work Days" wrote:

I have created a spreadsheet in which there is a committed ship date as
opposed to the actual ship date. However, I need this calculated difference
to be in work days. Does anyone have a formula for this?