THIS MIGHT BE A TOUGH ONE?

CAPT.PT · Mar 20th, 2002, 04:02 PM

I am making a payroll for the Fire Dept., We work alot differant hrs. than anyone else, trust me!

Our pay period runs every 14 days, so I have worksheets to cover that with one big problem..I have to incorporate the Fair Labor Standards Act (FLSA) that runs on a 27 day cycle.
Qusetion is, if I make templates for the normal pay periods of 14 days...how can I incorporate this other cycle? This hardly ever starts on the same day as the pay period!

Any suggestions?
Thanks

eliW · Mar 21st, 2002, 04:14 AM

Quote:

On 2002-03-20 15:02, CAPT.PT wrote:
I am making a payroll for the Fire Dept., We work alot differant hrs. than anyone else, trust me!

Our pay period runs every 14 days, so I have worksheets to cover that with one big problem..I have to incorporate the Fair Labor Standards Act (FLSA) that runs on a 27 day cycle.
Qusetion is, if I make templates for the normal pay periods of 14 days...how can I incorporate this other cycle? This hardly ever starts on the same day as the pay period!

Any suggestions?
Thanks

Maybe you'll find it here:
http://www.workforcesoftware.com/labor-laws/flsa.html
Eli

[ This Message was edited by: eliW on 2002-03-21 11:07 ]

KniteMare · Mar 21st, 2002, 11:59 AM

Day one week one will co-incide every 378 days, (14 X 27) you will need to set the template up for that period. (Ours runs every 112 days here in Corrections) I used Case Statements for my master roster program. I have 5000 employees who work 5 days on 3 days off and 1000 employees who work a non standard schedule that repeats every 112 days with no two shifts exactly alike, and I have 125 who work 4 on 4 off 5 on 3 off, 10 hour day. If you set each schedule up in a seporate module it makes it easier to trouble shoot.

Yours in EXCELent Frustration
KniteMare

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 04:02 PM	#1
CAPT.PT New Member Join Date: Mar 2002 Posts: 32	I am making a payroll for the Fire Dept., We work alot differant hrs. than anyone else, trust me! Our pay period runs every 14 days, so I have worksheets to cover that with one big problem..I have to incorporate the Fair Labor Standards Act (FLSA) that runs on a 27 day cycle. Qusetion is, if I make templates for the normal pay periods of 14 days...how can I incorporate this other cycle? This hardly ever starts on the same day as the pay period! Any suggestions? Thanks

Mar 21st, 2002, 11:59 AM	#3
KniteMare Board Regular Join Date: Mar 2002 Location: Hilo, Hawaii Posts: 240	Day one week one will co-incide every 378 days, (14 X 27) you will need to set the template up for that period. (Ours runs every 112 days here in Corrections) I used Case Statements for my master roster program. I have 5000 employees who work 5 days on 3 days off and 1000 employees who work a non standard schedule that repeats every 112 days with no two shifts exactly alike, and I have 125 who work 4 on 4 off 5 on 3 off, 10 hour day. If you set each schedule up in a seporate module it makes it easier to trouble shoot. Yours in EXCELent Frustration KniteMare