OK fixed the #NUM! error, forgot the "" around Ford. How do I configure it
to count just the 8 hour work day, minus weekends and holidays?

"stkinkuwait" wrote:

The formula I am using is returning a #NUM! error.

=IF(A:A=Ford,TEXT(C:C-B:B,"hh:mm"),0)

Of course this is way above my user level too so the error is between the
seat back and the keyboard.

"stkinkuwait" wrote:

Thanks in advance for any help!

I am trying to calculate the average time it takes to accomplish a specific
task amongst many tasks during an 8 hour weekday, excluding holidays. Work
day is from 8 AM to 4 PM.

Model Date Received Date finished
Ford 10/17/07 8:30 AM 10/18/07 12:00 PM
Chevy 10/17/07 8:00 AM 10/17/07 12:00 PM
Ford 10/17/07 8:00 AM 10/17/07 12:00 PM
Chevy 10/17/07 8:40 AM 10/17/07 12:00 PM
Ford 10/18/07 9:41 AM 10/19/07 12:00 PM
Dodge 10/18/07 9:15 AM 10/18/07 12:00 PM


What formula would allow me to find out the average time it takes to process
a Ford?

Thanks again!