View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
watty watty is offline
external usenet poster
 
Posts: 6
Default calculate the difference between negative and positive values

That works! Thank you

wrote:
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"