use addition function

[Guest]

I have in my a format I need help on. I have an column called hours that I
enter hours charged. All my clients get 5 hour free, so I only want to charge
for the hours over 5. I found an example to do a sum =Sum([Hour]) total to
get the total hours because i visit there offices and enter maybe 1 here and
2 hours there during the month. How would I minus out 5 from the total and
then charge the remainer amount x 85. If I the amount is less than 5 hours I
want this field to show no charge, or 0.

(((Total) - 5) *85) ?
if field is >5, (no charge or 0)

 

[Wayne Morgan]

This should give you the value. If the result of the subtraction is >0, then
multiply by 85; otherwise, return 0.

=IIf(Total-5>0, (Total-5)*85, 0)

 

[John Vinson]

I have in my a format I need help on. I have an column called hours that I
enter hours charged. All my clients get 5 hour free, so I only want to charge
for the hours over 5. I found an example to do a sum =Sum([Hour]) total to
get the total hours because i visit there offices and enter maybe 1 here and
2 hours there during the month. How would I minus out 5 from the total and
then charge the remainer amount x 85. If I the amount is less than 5 hours I
want this field to show no charge, or 0.

(((Total) - 5) *85) ?
if field is >5, (no charge or 0)

=0.85 * IIF(Sum([hour]) > 5, Sum([Hour]) - 5, 0)

John W. Vinson[MVP]