Do you want to prorate hours?


This option is available to users of e-timecard standalone only. The export program can calculate prorated hours based on the standard hours divided by the actual hours entered by the employee. You establish standard hours on the Employee Types screen. The proration does not change the actual time card record. It affects only the ASCII export file.

If you check the Calculate Prorated Hours box, then you must turn this feature on for each employee type for which you want to perform the calculation. Also note that you can exclude certain earning codes from the proration calculation.

Example

An employee enters the following hours on a time card.

Job

Earning code

6/7

6/8

6/9

6/10

6/11

Total

AAA

REG

5

 

5

 

 

10

BBB

REG

10

10

10

10

10

50

CCC

REG

 

 

 

 

10

10

Total hours

 

15

10

15

10

20

70

The standard hours for this employee’s employee type is 40. When you run an export, the program calculates the factor to prorate as follows.

standard hours/ total time card hours for the period
= 40 / 70
= 0.57

e-timecard can generate the ASCII file by either a summary record for each job/earning code combination or a detail record for every entry on the time card. Read details on selecting one of these options.

If e-timecard generates the ASCII file by summary, then the program multiplies the total hours for each job/earning code by the prorate factor to obtain the prorated hours. This information appears in the ASCII file:

Job

Earning code

Total hours

Prorated hours

AAA

REG

10

5.71

BBB

REG

50

28.58

CCC

REG

10

5.71

If e-timecard generates the ASCII file by a detail record for every time card entry, then the program multiplies the hours for each job for each day by the prorate factor to obtain the prorated hours. This information appears in the ASCII file:

Job

Earning code

Date

Hours

Prorated hours

AAA

REG

6/7

5

2.88

AAA

REG

6/9

5

2.86

BBB

REG

6/7

10

5.71

BBB

REG

6/8

10

5.71

BBB

REG

6/9

10

5.71

BBB

REG

6/10

10

5.71

BBB

REG

6/11

10

5.71

CCC

REG

6/11

10

5.71