View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default 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"