Hi,
I'm hoping for some help with a networkdays formula; i've used the same formula (referencing different cells) in 2 columns and the results that it has returned are brilliant. However, i would like to expand on both formulas, individually, just to remove some small issues errors when returning data. All cells are formatted to [h]:mm:ss
The first formula is: =((NETWORKDAYS(U2,W2)-1)*("16:30"-"8:00")+MOD(W2,1)-MEDIAN(NETWORKDAYS(U2,U2)*MOD(U2,1),"8:00","16:30"))
What I would like this formula to do is return a blank value if column U is not populated; currently its is populating it with data that is irrelevant
The second forumla is the same but referencing different cells: =((NETWORKDAYS(T2,W2)-1)*("16:30"-"8:00")+MOD(W2,1)-MEDIAN(NETWORKDAYS(T2,T2)*MOD(T2,1),"8:00","16:30"))
With this formula, if the column W has a lesser value than T, I just get '##########' within the cell; is it possible to return this has a minus firgue (i.e. -04:00:00); if not then simply returning it has a 0 would be fantastic.
Thank you in adavance and a happy new year for tomorrow
Chris
I'm hoping for some help with a networkdays formula; i've used the same formula (referencing different cells) in 2 columns and the results that it has returned are brilliant. However, i would like to expand on both formulas, individually, just to remove some small issues errors when returning data. All cells are formatted to [h]:mm:ss
The first formula is: =((NETWORKDAYS(U2,W2)-1)*("16:30"-"8:00")+MOD(W2,1)-MEDIAN(NETWORKDAYS(U2,U2)*MOD(U2,1),"8:00","16:30"))
What I would like this formula to do is return a blank value if column U is not populated; currently its is populating it with data that is irrelevant
The second forumla is the same but referencing different cells: =((NETWORKDAYS(T2,W2)-1)*("16:30"-"8:00")+MOD(W2,1)-MEDIAN(NETWORKDAYS(T2,T2)*MOD(T2,1),"8:00","16:30"))
With this formula, if the column W has a lesser value than T, I just get '##########' within the cell; is it possible to return this has a minus firgue (i.e. -04:00:00); if not then simply returning it has a 0 would be fantastic.
Thank you in adavance and a happy new year for tomorrow
Chris