Get instant live expert help on how to calculate mod
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have used a MOD forumla to calclaute my staff working hours on the rota, however when they have worked over 6 hours i want to take 30mins off for dinner how do i add and if statment to mod
Solved by F. A. in 17 mins
=IF(AND(e2<=50), e2*114%*120%)
=e2-MOD(e2,10)+4*(MOD(e2,10)>5)+5
Solved by I. B. in 29 mins
I need a formula to calculate the average between a group of cells however the cells contain the below formula:
=IF(C41="Y",(INT(NETWORKDAYS.INTL(A41, I41, 1,)/5)-1&" Weeks "&MOD(NETWORKDAYS.INTL(A41, I41, 1,),5)&" Days"),(INT(NETWORKDAYS.INTL(A41, I41, 1,)/5)&" Weeks "&MOD(NETWORKDAYS.INTL(A41, I41, 1,),5)&" Days"))
I've tried using the Average formula but responds with #Div/0!
Solved by E. L. in 30 mins
How do I explain this calculation
a. =(NETWORKDAYS(C2,G2,$O$2)-1)*("17:00"-"8:00")+IF(NETWORKDAYS(G2,G2,$O$2),MEDIAN(MOD(G2,1),"17:00","8:00"),"17:00")-MEDIAN(NETWORKDAYS(C2,C2,$V$2)*MOD(C2,1),"17:00","8:00")
Solved by O. B. in 12 mins
average if function correction for mod 8
Solved by G. E. in 11 mins