Limiting Decimal points

Hi

I have two layouts and one is a copy of the other.
In Layout A Table 1
I have a time field showing hh mm ss.This field is a calculation of number of hours to complete a task.Set as Time in the calc  eg 5:04:12 and the filed displays just that which is what I want.When I click in  this field the the result is expanded to show 5:04:129999999.

In Layout B Table 2
The same result appears but is is confined to hh mm ss and does not expand to multipl decimal points.

The Data in both cases is formated to Time ''As Entered''

I know it is a simple issue and would appreciate some direction on this
KrisraychrisAsked:
Who is Participating?
 
Will LovingConnect With a Mentor PresidentCommented:
I curious about your comments about "the extensive script that is associated with these fields"... Are these simply Time fields that you are setting the value in using a script or are the Calculation fields with Time results? Either way, if you can upload a sample file with the calculations (or script) I can take a look at it.

Sometimes creating a sample file can actually help solve a problem like this because it forces you to eliminate variables. If the problem disappears, then it's something you took out to make it simpler for the sample; if it's still there then you have fewer variables left to consider. It does sound like the issue is with the calculation, whether scripted or in the field definition.

However, the one other thing that comes to mind is to look at the original source values. Sometimes an unrounded decimal such as you are seeing is there from the start in one of the values that you are using to perform the calculation rather than a result of the calculation you are performing. I've had this happen more than once over the years!
0
 
Will LovingPresidentCommented:
If both fields are identically formatted to "As Entered", my guess is that it would have to do with differences between the calculations in the two fields. Make sure that both calculations who "Time" as the result type and are structured similarly. Also, as an experiment, try recreating both calculation fields from scratch in two new fields, one in each table, and then see if you get the same result.

It doesn't sound like a formatting issue, but you can always try copying the field on one table and placing that copy of the other table. Then, double-click on the field you just copied and change it to the local field in the table the layout is based on. If it's a formatting issue it should show the difference between the two layout fields that both reference the same calculation.

If that still doesn't do it, create and upload a sample file that just has the two tables and the fields necessary for the calculation, along with a layout for each table showing one working one way - not rounded - and one with rounding of the decimal.
0
 
KrisraychrisAuthor Commented:
Thanks for the input.I have tried the options you suggested.There seems to be no consistency and could be a result of the extensive script that is associated with these fileds.
I thought a simpler solutoion might be to create a duplicate of the field and set it to Round the number.This works but I dont think it is the right way to go.I will work throgh it in greater details and try to find the source of the problem.
0
 
KrisraychrisAuthor Commented:
Thank you .I had a source field which was I rounded and sorted out the problem.
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.