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)
Bookmarks