Calculate working hours between two dates/times

I am need the following formula in Microsoft SharePoint to calculate the number of hours between two dates and times, for working hours and exclude the weekends.

=IF(AND((WEEKDAY([Date & Time Request Ends],2))<(WEEKDAY([Date & Time request Starts],2)),((WEEKDAY([Date & Time request Starts],2))-(WEEKDAY([Date & Time Request Ends],2)))>1),(((DATEDIF([Date & Time request Starts],[Date & Time Request Ends],"D")+1))-(FLOOR((DATEDIF([Date & Time request Starts],[Date & Time Request Ends],"D")+1)/7,1)*2)-2),(((DATEDIF([Date & Time request Starts],[Date & Time Request Ends],"D")+1))-(FLOOR((DATEDIF([Date & Time request Starts],[Date & Time Request Ends],"D")+1)/7,1)*2)))

I tried adding this to the end of the formula but it didn't work.

INT(([Date & Time Request Ends]-[Date & Time request Starts])*24)

The following are two user-defined function analogous to WorkDays and NetWorkDays.

WorkHours (StartDate, NumerofHours, Shift_Start_Time, Shift_End_Time, [Holidays]) - computes end time of job given a start time and number of hours.

NetWorkHours(Shift_Start_Time, Shift_End_Time, Start_Time, End_Time,[Holidays]) - computes number of hours worked given a start time and end time

Please Login or Register  to view this content.

Please Login or Register  to view this content.