Hi there GMv1,

Assuming "2/19/2010 16:00" is in cell A1 and "2/22/2010 9:00" is in cell B1.
The formulae in cell C1 would be as follows :
=INT((B1-A1)*24)

Let us know if this helps you.
--

Thank you and Regards

Garreth Lombard


"GMv1" wrote:

I am trying to find the diff in hours only between 8:00 and 17:00 Monday to
Friday only, any hours that fall outside of that time frame should not be
counted. Each calculation will have different dates so if there is a way to
do this without specifying the date that would be great!

2/19/2010 16:00 2/22/2010 9:00 ???

Thanks for any assistance you can offer!