Summing with maximums

  • Thread starter Thread starter hossa_dude
  • Start date Start date
H

hossa_dude

Hi Guys...yet another problem.
I'll have to do some calculations for my HR dept.
Therefore, I get a list of how many hours a person worked per day in
given calendar month.
What I want to do is sum those figure for the respective month.
However, if a person works more than 8h a day, 8 should be the maximu
number to be included in the summing. On the contrast, if he work
below 8h per day, the actual figure should be included, eg.
Day 1: 8
Day 2: 7.5
Day 3: 9
The correct sum should equal: 23,5 (i.e. 8, 7.5 and 8) and NOT 24,5 (8
7.5, 9)

Any idea on how to do that?

Kind regards
Joer
 
On word: perfect....any other words? Thank you :)
That helped....didn't know that it was so easy.....
Great work..
 
Back
Top