How do I apply a round to Format([RegHrs]/[OTHrs], "Percent") so that I get 99% instead of 98.64%?
T Tyler at Creme Dec 30, 2008 #1 How do I apply a round to Format([RegHrs]/[OTHrs], "Percent") so that I get 99% instead of 98.64%?
J John W. Vinson Dec 30, 2008 #2 How do I apply a round to Format([RegHrs]/[OTHrs], "Percent") so that I get 99% instead of 98.64%? Click to expand... Format(Round([RegHrs]/[OTHrs], 2), "Percent") Round to two decimals (0.9864 becomes 0.98) and then format.
How do I apply a round to Format([RegHrs]/[OTHrs], "Percent") so that I get 99% instead of 98.64%? Click to expand... Format(Round([RegHrs]/[OTHrs], 2), "Percent") Round to two decimals (0.9864 becomes 0.98) and then format.
