I'm using this formula in a calculated field to calculate the number of work days between 2 dates, but I need it to be more specific and calculate the number of work hours:
=IF(NOT(ISBLANK([Return date])),IF(AND((WEEKDAY([Return date],2))<(WEEKDAY([Beginning Date],2)),((WEEKDAY([Beginning Date],2))-(WEEKDAY([Return date],2)))>1),(((DATEDIF([Beginning Date],[Return date],"D")+1))-(FLOOR((DATEDIF([Beginning Date],[Return date],"D")+1)/7,1)*2)-2),(((DATEDIF([Beginning Date],[Return date],"D")+1))-(FLOOR((DATEDIF([Beginning Date],[Return date],"D")+1)/7,1)*2))),"")
Assumptions: 8hr work day, "Beginning Date" and "Return Date" are date and time fields. Need to be able to calculate partial days.