Take a look at Chip Pearson's solution at
http://www.cpearson.com/excel/DateTimeWS.htm
Steve
"Mickey" wrote in message
...
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