在Sharepoint中实现Excel中的NetWorkDays函数功能

Sharepoint中没有NetWorkDays函数，当然，只实现了两个参数的方法（StartDate和EndDate） 其中A1为StartDate。B1为EndDate。
=DATEDIF(A1,B1,"d")+1-IF(WEEKDAY(A1,2)<6,0,8-WEEKDAY(A1,2))-IF(WEEKDAY(B1,2)<6,0,WEEKDAY(B1,2)-5)-FLOOR((DATEDIF(A1,B1,"d")+1-IF(WEEKDAY(A1,2)<6,0,8-WEEKDAY(A1,2))-IF(WEEKDAY(B1,2)<6,0,WEEKDAY(B1,2)-5))/7,1)*2

以12点到13点之间是休息时间为例，计算两个时间段内的请假时间（小时数）
=((TEXT(B1,"hh:mm")-TEXT(A1,"hh:mm"))-IF((AND(HOUR(A1)=12,HOUR(B1)=12)),TEXT(B1,"hh:mm")-TEXT(A1,"hh:mm"),IF(AND((TEXT(A1,"hh:mm")<="12:00"),(TEXT(B1,"hh:mm")>="13:00")),1/24,IF(HOUR(A1)=12,"13:00"-TEXT(A1,"hh:mm"),TEXT(B1,"hh:mm")-"12:00"))))*24