The Elapsed time parameters dialog box provides seven (7) different Calculation methods for determining the service earned between two dates. For all of the methodologies below, ProAdmin treats stop dates as the first day not worked; the last day worked is the day before the stop date.

The illustrative calculations shown below are based on the assumptions that the measurement period is a calendar year, the start date is 9/25/1985 and the stop date is 7/31/2004.

The Date Subtraction: (years + months/12 + days/ method calculates elapsed time service by summing three amounts. The first amount is the end year minus the start year; second amount is the end month minus the start month and dividing the result by 12; and the third amount is the end day minus the start day and dividing the results by either 365.25 or 360:

• Select 365.25 to calculate elapsed time service using the date subtraction method with 365.25 as the denominator for the day subtraction. Under this method, our illustrative service calculation proceeds as follows:

	2004 – 1985	= 19
	(7 – 9) / 12	= - 0.166667
	(31 – 25) /365.25	= 0.016427
	19 - 0.166667 + 0.016427	= 18.849760

• Select 360 (with end of months reset to the 30^th) to calculate elapsed time service using the date subtraction method with 360 as the denominator for the day subtraction. For this calculation, if either the start day or the end day is the end of the month, that day is replaced with 30. Under this method, our illustrative service calculation proceeds as follows:

	2004 – 1985	= 19
	(7 – 9) / 12	= - 0.166667
	(30 – 25) /360	= 0.013889
	19 - 0.166667 + 0.013889	= 18.847222

The Calendar Days: (date2 – date1)/ method calculates elapsed time service as a ratio of the number of days the member was eligible for service during the measurement period to the number of days there were during the measurement period. In determining days worked, the stop date is not included. For this calculation, there are two choices for the number of days assumed during the measurement period:

• Select True days (365 or 366) to calculate elapsed time service as the difference between two dates, recognizing leap years. Under this method, our illustrative service calculation proceeds as follows:

	98 / 365	= 0.268493	98 days worked in 1985
	2004-1986	= 18 full measurement periods	for 1986 through 2003
	212 / 366	= 0.579235	212 days worked in 2004
	0.268493 + 18 + 0.579235	= 18.847728

• Select 365 days to calculate elapsed time service as the difference between two dates in days divided by 365. Using this method, leap years will accrue an additional 1/365 of service. Under this method, our illustrative service calculation proceeds as follows:

6,884 / 365

= 18.860274 (6,884 days worked from 09/25/1985 to 07/31/2004)

 The Calendar months + additional months from extra days method determines elapsed time service by counting the number of completed calendar months between two dates, and then any days not counted in the calendar months are converted into additional months of service based on the extra day assumptions specified. For example, if you are hired on 7/16/2010, then the first completed month (i.e., the first month where every day was worked) is earned on 8/31/2010 (assuming you are using +1day as a stop date adjustment).  The days from 7/16/2010 to 7/31/2010 are 16 extra days. On 8/31/2010, you would have 1 completed full calendar month and 16 extra days.

The extra days can be converted into additional months of service using Extra days for a month and Leftover days for another month. Assuming 30 Extra days for a month and 15 Leftover days for another month, if you ask how much service do I have on [7/16/2010,8/31/2010], you would have 2 months of service: 1 completed month (for August) and since the 16 extra days is greater than the 15 Leftover days for another month assumption, an additional month is earned for the 16 extra days.  If you ask how much service do I have on [7/16/2010,8/30/2010], which is 46 extra days, you would still have 2 months of service: 0 completed months, 1 additional month for 30 Extra days for a month, and another month for the 16 (i.e., 46-30) Leftover days for another month assumption.

Now suppose someone is hired 7/16/2010 and terminates 3/13/2015, and then is rehired 4/27/2018 and terminates 6/28/2022. How much service is earned (assuming they get 1 day of service credit on the termination dates)? If we are assuming 30 Extra days for a month and 15 Leftover days for another month, then

Period Worked	Net Completed Months	Net Extra days	Accumulated Completed Months	Accumulated Extra days	Service
[07/26/2010, 07/31/2010]	0	6	0	6	0.000000
[08/01/2010, 02/28/2015]	55	0	55	6	4.583333
[03/01/2015, 03/10/2015]	0	10	55	16	4.666667
[04/27/2018, 04/30/2018]	0	4	55	20	4.666667
[05/01/2018, 05/31/2022]	49	0	104	20	8.750000
[06/01/2022, 06/29/2022]	0	29	104	49	8.833333

Note, that on 6/29/2022, we have 104 completed months and 49 extra days. The 104 completed months represents 8.666667 years of service (104/12). When we convert the 49 extra days into months of service, we truncate 49/30 to get 1 month, and then the 19 left over days (49-30), is greater than or equal to 15 Leftover days for another month, so we get another month. Now, the total service is 8.666667 + 0.083333 + 0.083333 = 8.833333

The Business Days method determines elapsed time service as a ratio of the number of Mondays through Fridays for which the member was eligible for service during the measurement period to the actual number of Mondays through Fridays during the measurement period. Under this method, our illustrative service calculation proceeds as follows:

	70 / 261	= 0.268199	for 1985
	2004-1986	= 18 full measurement periods	for 1986 through 2003
	152 / 262	= 0.580153	for 2004
	0.268199 + 18+ 0.580153	= 18.848352

The 360 days per year (30 per month) method determines elapsed time service as the number of days counted in a measurement period divided by the number of days assumed to be in the measurement period, and then multiplied by the fractional weight of the measurement period (1/12 if monthly, 1/26 if bi-weekly, etc.), where each full month worked is counted as 30 days and a year is assumed to consist of twelve 30-day months. Under this method, our illustrative service calculation proceeds as follows:

	6 / 30 / 12	= 0.268199	for 1985
	3 / 12	= 0.25	for October – December, 1985
	2004-1986	= 18 full measurement periods	for 1986 through 2003
	7 / 12	= 0.583333	for January – July, 2004
	0.016667 + 0.25 + 18 + 0.583333	= 18.85

The Start date field is requested when no Event Definition is selected. Choose a database field from the Data Dictionary, such as “DateOfHire”, to indicate when service begins.