negative time in Hours and mins
With hours to work in A1 and
actual worked in B1 try the below formula in C1
=IF(B1=A1,B1-A1,"-"&TEXT(ABS(B1-A1),"hh:mm"))
PS: This is only for display and not for calculations; as excel do not
display negative time..
If this post helps click Yes
---------------
Jacob Skaria
"Matt" wrote:
is there a way i can show negative time eg needs to work 3:00 hours but only
works 2:00 hours it will come up as -1:00hours but if then they do an extra
2:00 hours it will show 1:00
|