View Single Post
  #5   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

Thanks for those very useful responses - I have been able to solve the
problem.

One question following - using your suggested formulas I am also
setting up fields to show that, for example, this month employee A is
working for 1 hour 20 minutes longer that last month. 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.

Many thanks (and sincere apologies for my terrible maths in the
original question!)

watty wrote:
I need to show the difference between costings for last month, compared
with this month.

For example, last month a particular costing showed a profit of $100.
This month is showing a loss of -$200. I need to show that this month
the difference between the costings is therefore -$100, or, $100
dollars less than last month.

Can anyone offer me the formula to do this?

Sneaky second question!... it would be useful to display, in the above
example, "$100 less", rather than "-$100". Can this be done?

Many thanks