calculate the difference between negative and positive values
watty wrote:
This value is
expressed as a decimal, i.e. the employee is working 1.33 hours more.
The formula however only returns "1 hour more" and does not recognise
the fractional part of the number. How can I adjust the formula to
display this.
=text(A1-A2, "0.00") & " more"
|