Addition of two user defined fields

  • Thread starter Thread starter hazard hanson
  • Start date Start date
H

hazard hanson

New to Outlook formulas. I have two fields (Total Site Hrs) that total the
number of hours worked on site and (Total Off Site Hrs) the total number of
hours worked off site these are working well but need to add the two fields
together to form a thrid field. I have called my third field Total Hrs and
have used the formula

([Total Site Hrs]+[Total Offsite Hrs]) The result should be 3.00+4.00=7.00.
The result I get is 3.004.00

Hence Outlook appers to be combining the results from each field rather tahn
adding them.

Any help would be greatly appreciated!

Tony.
 
Are the fields of the type text? They should be of a numeric value.

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 30 Jul 2008 06:52:00 -0700 schrieb hazard hanson:
 
The fields are Formula Type but I have noticed that by changing the formula to
([Total Site Hrs]--[Total Offsite Hrs]) I get the correct result., not sure
why?

Michael Bauer said:
Are the fields of the type text? They should be of a numeric value.

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 30 Jul 2008 06:52:00 -0700 schrieb hazard hanson:
New to Outlook formulas. I have two fields (Total Site Hrs) that total the
number of hours worked on site and (Total Off Site Hrs) the total number of
hours worked off site these are working well but need to add the two fields
together to form a thrid field. I have called my third field Total Hrs and
have used the formula

([Total Site Hrs]+[Total Offsite Hrs]) The result should be 3.00+4.00=7.00.
The result I get is 3.004.00

Hence Outlook appers to be combining the results from each field rather tahn
adding them.

Any help would be greatly appreciated!

Tony.
Click to expand...
Click to expand...
 
Back
Top