Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IFERROR(WORKDAY(E5,H5/24,Holidays!$A$2:$A$37)+MOD(E5,1)+MOD(H5,24)/24,"")
- =IF(WORKDAY(E5,H5/24,Holidays!$A$2:$A$37)+MOD(E5,1)+MOD(H5,24)/24>WORKDAY(E5,H5/24,Holidays!$A$2:$A$37)+MOD(E5,1)+TIME(23,30,0),WORKDAY(E5,H5/24,Holidays!$A$2:$A$37)+MOD(E5,1)&TIME(11,30,0),WORKDAY(E5,H5/24,Holidays!$A$2:$A$37)+MOD(E5,1)+MOD(H5,24)/24)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement