q; Compare Two Dates

I need to compare tow dates DateField1 and DateField2 and find number of
hours between these two dates. Then I need to deduct non-business days and
hours (Business days: Monday-Friday and Business Hours: 7:00am-7:00pm) from
this and find net hours. How can I do this?Hello,
Take a look into DATEDIFF function
Thanks
Hari
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:37184CE4-A112-4034-B464-59909C0FAB2A@.microsoft.com...
>I need to compare tow dates DateField1 and DateField2 and find number of
> hours between these two dates. Then I need to deduct non-business days and
> hours (Business days: Monday-Friday and Business Hours: 7:00am-7:00pm)
> from
> this and find net hours. How can I do this?