Solved Limit the Decimals to 2 Digits

JithuAccess

Member
Local time
Today, 12:53
Joined
Mar 3, 2020
Messages
325
Hello Guys,

I want to find the Total Review Time. This is my Code

Code:
Text34.Value = Nz(DateDiff("n", [Review Start Time], [Review End Time]) / 60, 0)

This is working Perfect.

1622564459494.png


But when I change Times like:

1622564501043.png

Total Review Time is showing Decimals like this. These are the Properties of my Text Box:

1622564565112.png


and these are the field properties of Total Review Time:

1622564619218.png


Could you guys please let me know how to limit the Decimals to 2? In the above Example, the value should be 8.17.

Thanks a lot
 
I think I fixed this. I use this code

Code:
Text34.Value = Nz(DateDiff("n", [Review Start Time], [Review End Time]) / 60, 0)
Text34.Value = Round(Text34.Value, 2)

Thank You
 

Users who are viewing this thread

Back
Top Bottom