RonNCmale
04-12-2010, 05:44 AM
Attached is a time report that is almost perfect. I have two glitches remaining. If January 1 falls in wk 50 of the previous year and Martin Luther King's Holiday is given in wk 1. Is there any way of manually keying in the date from the previous year for New Year's day Holiday or any other holiday and keep the Holiday sheet in the order they are keyed in on the Time report. example New Year's Holiday would be manually keyed in for 1/1/09 on the Holiday Sheet. Then when on wk 1, 8.00 hrs is posted on 1/18/10 (Martin Luther Kings Holiday) it is posted on 1/18/10 as the (B) Holiday. Or if New Year's Holiday, and Martin Luther King Holiday is keyed in manually, the next Holiday that is entered on the the time report is the next holiday which would be Good Friday Holiday.
The second glitch, Again due to 13 pay periods on one of the pay periods the employee is receiving an extra earned leave. The formula gives the correct earned leave in accordance with years of service and on the employees anniversary date. Is there a way to add to the formula if during the pay period the 15th of the month does not show up, no leave is entered for that pay period. example wk 1 thru wk 4 (1/17/10 to 2/13/10) for that pay period no leave would be earned.
The second glitch, Again due to 13 pay periods on one of the pay periods the employee is receiving an extra earned leave. The formula gives the correct earned leave in accordance with years of service and on the employees anniversary date. Is there a way to add to the formula if during the pay period the 15th of the month does not show up, no leave is entered for that pay period. example wk 1 thru wk 4 (1/17/10 to 2/13/10) for that pay period no leave would be earned.