Help with Formula

[Ranger32195]

Good afternoon,

I have the following formula that provides me with a number depending on time elapsed between specific dates, eg 1, 2 3 etc

=3*(NETWORKDAYS(K1127,L1127)-1)+MATCH(HOUR(L1127),{0,12,17})

I am now looking to modify the above so that anything with a difference of less than 1.5 network days (Or anything less than noon the following network day) to equal 1 - anything greater than noon the following network dayto be 2....

=1*(NETWORKDAYS(R150,P150)-1)+MATCH(HOUR(P150),{0,36})

Thanks in advance

 

[Ranger32195]

Apologies for the bump...

Good afternoon,

I have the following formula that provides me with a number depending on time elapsed between specific dates, eg 1, 2 3 etc

=3*(NETWORKDAYS(K1127,L1127)-1)+MATCH(HOUR(L1127),{0,12,17})

I am now looking to modify the above so that anything with a difference of less than 1.5 network days (Or anything less than noon the following network day) to equal 1 - anything greater than noon the following network dayto be 2....

=1*(NETWORKDAYS(R150,P150)-1)+MATCH(HOUR(P150),{0,36})

Thanks in advance

 

[Ranger32195]

...