MDAS Rule

[mcjavier]

Hi -

Sanity check

Say i have figures for the said columns on the formula below in hour format

(J2+K2+L2+M2+N2+O2+(P2-Q2)+R2+S2)-(J2+T2+U2)/3600)

is it correct?

Thank you

MC

[NeedForExcel]

Maybe you can make the formula a bit better.

=(SUM(J2:O2)+(P2-Q2)+SUM(R2:S2))-(J2+SUM(T2:U2)/3600)

Please check if the answer is matching though, coz I am not sure what sequence of calculation you are looking for.. Even a bracket here and there can make a difference in the result..

[FDibbins]

Or perhaps this...
(J2+K2+L2+M2+N2+O2+(P2-Q2)+R2+S2)-(J2+T2+U2)/3600)
=(sum(K2:S2)-(Q2*2+T2+U2)/3600