I am using the following formula to calculate the difference between two times :
if(K5>=K4,K5-K4,K4-K5)
however when K5 is less than K4 formula returns #############
Not sure what I am doing wrong had it working earlier, unless a format has now changed??
The times never cross over 24hrs.
if(K5>=K4,K5-K4,K4-K5)
however when K5 is less than K4 formula returns #############
Not sure what I am doing wrong had it working earlier, unless a format has now changed??
The times never cross over 24hrs.