How do I calculate the week day hours between 2 days

I need to calculate the difference in hours between when I received a project
and when when I completed the project. Within this time frame I do not want
to count weekends and I want the workday to be 8:00 am to 8:00 pm.

Example (9/11/5 8:00 am started and 9/12/5 8:00 am finished)= 12 hours not
24 hours

Is there an easy way to do this?
--
Mickey

Take a look at Chip Pearson's solution at
http://www.cpearson.com/excel/DateTimeWS.htm

Steve


"Mickey" <Mickey@discussions.microsoft.com> wrote in message
news:9F5C1698-DED1-4285-846B-AD72CBBB01A3@microsoft.com...
>I need to calculate the difference in hours between when I received a
>project
> and when when I completed the project. Within this time frame I do not
> want
> to count weekends and I want the workday to be 8:00 am to 8:00 pm.
>
> Example (9/11/5 8:00 am started and 9/12/5 8:00 am finished)= 12 hours not
> 24 hours
>
> Is there an easy way to do this?
> --
> Mickey