Skip to Content
0
Former Member
Nov 20, 2012 at 05:52 PM

average calculation for last 6 months

52 Views

Hello experts,

I need to calculate a rather strange average for period May-October. Our payroll is quincenal meaning 15 days.

For people with complete period there is no problem. I have problems with average for people with entry in this period.

For example> person entry 25 Jun. For average calculation I need to take the salary for the whole period of 15 days starting with 15 Jun even if person worked only 6 days in Jun.

What is the best way to do this calculation?

Thank you all.