Payroll Dilemna

[incognito8095]

Hello excellent helpers,

Thanks first of all for the responses I always get on here.

Question: There are several number fields on my form that are calculate fields, which I will show later what the expression is, that are not rounding off to 2 decimals as I am asking it to. How do I fix this?

The expression: =(((([Wednesday End Time]-[Wednesday Start Time])*24)*60)/60). This is a control box located under two fields (Start time and End time). The fields are formatted as 08:00AM.

So if I did 08:00AM to 05:20PM, the result would be 9.333333333....This does not mean much for the day as it adds up to be only cents, but over the week it becomes dollars. If the actual number was 9.33, it would be ok. No use in explaining that, you all get the idea.

 

[Uncle Gizmo]

>>> There are several number fields<<< >>> not rounding off to 2 decimals as I am asking it to. How do I fix this <<<

By several number fields, I presume you mean text boxes . If that is the case, then set the format property for the text box to fixed, two decimal places.

 

[incognito8095]

That worked like a champ. It is always the littlest thing!