Addition of two user defined fields

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.
 
M

Michael Bauer [MVP - Outlook]

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:
 
H

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hour differnce, 22/10/06 22.00 to 23/10/06 22.50 in hh:mm 3
Help with a Form based off of a Table 1
Group By Date question - date format needs to be "general" 1
Group By Date issue - date format is "general" 4
Group by Date question (date format is "general") 1
Pivot Table Calculated Fields 4
have either a Calculated Expression or User Input 2
Setting the display format of a query using the DateDiff function 6

Top