Thread
:
calculate the difference between negative and positive values
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
watty
external usenet poster
Posts: 6
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"
Reply With Quote
watty
View Public Profile
Find all posts by watty