Limiting Decimal points
Posted on 2012-04-04
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