Calif OT Calculations
 

I have the first 5 days. I need the 6th and 7th day.

If they have less than 40 regular hour on the sixth day, then its regular up
until 40 then 1.5x. Same thing applies to the seventh day 48 hours. A work
day consists of at least 8 hours.

One and one-half times the employee's regular rate or pay for all hours
worked in excess of eight hours up to and including 12 hours in any workday,
and for the first eight hours worked on the seventh consecutive day of work
in a workweek; and
Double the employee's regular rate or pay for all hours worked in excess of
12 hours in any workday and for all hours worked in excess of eight on the
seventh consecutive day of work in a workweek.

Start Lunch End Total Reg 1.5x 2x

Sun 6 1 18 11 8 3
Mon 6 1 22.5 15.5 8 4 1.5
tue soso
wed soso
thur soso
fri (here is where I need help)
sat (and here)


I am using fractions ie (17.25= 5:15 pm) not hours. If someone has this it
would help me out so much.

Thank you in advance

Chase Michaels

Calif OT Calculations
 

So you don't have to re-invent the wheel, I've made up a couple of sheets
that the girls in the office use every Monday, to enter time card data and
calculate the previous week's payroll.
It's set for California rules.

If you're interested, send me an e-mail with an address where you'd like me
to e-mail you a copy.

Just cut out cutout from my address.

Regards,

RD

wrote in message
...
I have the first 5 days. I need the 6th and 7th day.

If they have less than 40 regular hour on the sixth day, then its regular
up
until 40 then 1.5x. Same thing applies to the seventh day 48 hours. A work
day consists of at least 8 hours.

One and one-half times the employee's regular rate or pay for all hours
worked in excess of eight hours up to and including 12 hours in any
workday,
and for the first eight hours worked on the seventh consecutive day of
work
in a workweek; and
Double the employee's regular rate or pay for all hours worked in excess
of
12 hours in any workday and for all hours worked in excess of eight on the
seventh consecutive day of work in a workweek.

Start Lunch End Total Reg 1.5x 2x

Sun 6 1 18 11 8 3
Mon 6 1 22.5 15.5 8 4 1.5
tue soso
wed soso
thur soso
fri (here is where I need help)
sat (and here)


I am using fractions ie (17.25= 5:15 pm) not hours. If someone has this it
would help me out so much.

Thank you in advance

Chase Michaels

Calif OT Calculations
 

Hi Chase,

I assume that my direct e-mails are not getting through to you. Three have
bounced so far and you said the 1st Spreadsheet that I sent you did not
arrive. I have tried again earlier with another spreadsheet but maybe
Ragdyer's sheet would be better.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


wrote in message
...
I have the first 5 days. I need the 6th and 7th day.

If they have less than 40 regular hour on the sixth day, then its regular
up
until 40 then 1.5x. Same thing applies to the seventh day 48 hours. A work
day consists of at least 8 hours.

One and one-half times the employee's regular rate or pay for all hours
worked in excess of eight hours up to and including 12 hours in any
workday,
and for the first eight hours worked on the seventh consecutive day of
work
in a workweek; and
Double the employee's regular rate or pay for all hours worked in excess
of
12 hours in any workday and for all hours worked in excess of eight on the
seventh consecutive day of work in a workweek.

Start Lunch End Total Reg 1.5x 2x

Sun 6 1 18 11 8 3
Mon 6 1 22.5 15.5 8 4 1.5
tue soso
wed soso
thur soso
fri (here is where I need help)
sat (and here)


I am using fractions ie (17.25= 5:15 pm) not hours. If someone has this it
would help me out so much.

Thank you in advance

Chase Michaels

Calif OT Calculations
 

Ragdyer,

That would be greatly appreciated.



thanks again

Chase Michaels

--

Chase Michaels

"Ragdyer" wrote in message
...
So you don't have to re-invent the wheel, I've made up a couple of sheets
that the girls in the office use every Monday, to enter time card data and
calculate the previous week's payroll.
It's set for California rules.

If you're interested, send me an e-mail with an address where you'd like
me to e-mail you a copy.

Just cut out cutout from my address.

Regards,

RD

wrote in message
...
I have the first 5 days. I need the 6th and 7th day.

If they have less than 40 regular hour on the sixth day, then its regular
up
until 40 then 1.5x. Same thing applies to the seventh day 48 hours. A
work
day consists of at least 8 hours.

One and one-half times the employee's regular rate or pay for all hours
worked in excess of eight hours up to and including 12 hours in any
workday,
and for the first eight hours worked on the seventh consecutive day of
work
in a workweek; and
Double the employee's regular rate or pay for all hours worked in excess
of
12 hours in any workday and for all hours worked in excess of eight on
the
seventh consecutive day of work in a workweek.

Start Lunch End Total Reg 1.5x 2x

Sun 6 1 18 11 8 3
Mon 6 1 22.5 15.5 8 4 1.5
tue soso
wed soso
thur soso
fri (here is where I need help)
sat (and here)


I am using fractions ie (17.25= 5:15 pm) not hours. If someone has this
it
would help me out so much.

Thank you in advance

Chase Michaels

Calif OT Calculations
 

You should *not* have openly posted your e-mail address.

The Spam Bots will get you!<g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
...
Ragdyer,

That would be greatly appreciated.



thanks again

Chase Michaels

--

Chase Michaels

"Ragdyer" wrote in message
...
So you don't have to re-invent the wheel, I've made up a couple of sheets
that the girls in the office use every Monday, to enter time card data
and calculate the previous week's payroll.
It's set for California rules.

If you're interested, send me an e-mail with an address where you'd like
me to e-mail you a copy.

Just cut out cutout from my address.

Regards,

RD

wrote in message
...
I have the first 5 days. I need the 6th and 7th day.

If they have less than 40 regular hour on the sixth day, then its
regular up
until 40 then 1.5x. Same thing applies to the seventh day 48 hours. A
work
day consists of at least 8 hours.

One and one-half times the employee's regular rate or pay for all hours
worked in excess of eight hours up to and including 12 hours in any
workday,
and for the first eight hours worked on the seventh consecutive day of
work
in a workweek; and
Double the employee's regular rate or pay for all hours worked in excess
of
12 hours in any workday and for all hours worked in excess of eight on
the
seventh consecutive day of work in a workweek.

Start Lunch End Total Reg 1.5x 2x

Sun 6 1 18 11 8 3
Mon 6 1 22.5 15.5 8 4 1.5
tue soso
wed soso
thur soso
fri (here is where I need help)
sat (and here)


I am using fractions ie (17.25= 5:15 pm) not hours. If someone has this
it
would help me out so much.

Thank you in advance

Chase Michaels

Calif OT Calculations
 

I *JUST REALIZED*, you've been doing that all along!

You're either very brave, or you have a darn good spam filter.<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
You should *not* have openly posted your e-mail address.

The Spam Bots will get you!<g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
...
Ragdyer,

That would be greatly appreciated.



thanks again

Chase Michaels

--

Chase Michaels

"Ragdyer" wrote in message
...
So you don't have to re-invent the wheel, I've made up a couple of
sheets that the girls in the office use every Monday, to enter time card
data and calculate the previous week's payroll.
It's set for California rules.

If you're interested, send me an e-mail with an address where you'd like
me to e-mail you a copy.

Just cut out cutout from my address.

Regards,

RD

wrote in message
...
I have the first 5 days. I need the 6th and 7th day.

If they have less than 40 regular hour on the sixth day, then its
regular up
until 40 then 1.5x. Same thing applies to the seventh day 48 hours. A
work
day consists of at least 8 hours.

One and one-half times the employee's regular rate or pay for all hours
worked in excess of eight hours up to and including 12 hours in any
workday,
and for the first eight hours worked on the seventh consecutive day of
work
in a workweek; and
Double the employee's regular rate or pay for all hours worked in
excess of
12 hours in any workday and for all hours worked in excess of eight on
the
seventh consecutive day of work in a workweek.

Start Lunch End Total Reg 1.5x 2x

Sun 6 1 18 11 8 3
Mon 6 1 22.5 15.5 8 4 1.5
tue soso
wed soso
thur soso
fri (here is where I need help)
sat (and here)


I am using fractions ie (17.25= 5:15 pm) not hours. If someone has this
it
would help me out so much.

Thank you in advance

Chase Michaels

Calif OT Calculations
 

Same situation as Sandy's ... e-mails are bouncing back.

Your address is *NG*!

No wonder you're not afraid of the Spam Bots!<bg
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

wrote in message
...
Ragdyer,

That would be greatly appreciated.



thanks again

Chase Michaels

--

Chase Michaels

"Ragdyer" wrote in message
...
So you don't have to re-invent the wheel, I've made up a couple of sheets
that the girls in the office use every Monday, to enter time card data and
calculate the previous week's payroll.
It's set for California rules.

If you're interested, send me an e-mail with an address where you'd like
me to e-mail you a copy.

Just cut out cutout from my address.

Regards,

RD

wrote in message
...
I have the first 5 days. I need the 6th and 7th day.

If they have less than 40 regular hour on the sixth day, then its regular
up
until 40 then 1.5x. Same thing applies to the seventh day 48 hours. A
work
day consists of at least 8 hours.

One and one-half times the employee's regular rate or pay for all hours
worked in excess of eight hours up to and including 12 hours in any
workday,
and for the first eight hours worked on the seventh consecutive day of
work
in a workweek; and
Double the employee's regular rate or pay for all hours worked in excess
of
12 hours in any workday and for all hours worked in excess of eight on
the
seventh consecutive day of work in a workweek.

Start Lunch End Total Reg 1.5x 2x

Sun 6 1 18 11 8 3
Mon 6 1 22.5 15.5 8 4 1.5
tue soso
wed soso
thur soso
fri (here is where I need help)
sat (and here)


I am using fractions ie (17.25= 5:15 pm) not hours. If someone has this
it
would help me out so much.

Thank you in advance

Chase Michaels

Calif OT Calculations
 

I am new and didn't know. I went to public school.

Try my office

See I am learning

Thanks
Chase

--

Chase Michaels

"RagDyeR" wrote in message
...
Same situation as Sandy's ... e-mails are bouncing back.

Your address is *NG*!

No wonder you're not afraid of the Spam Bots!<bg
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------


...
Ragdyer,

That would be greatly appreciated.



thanks again

Chase Michaels

--

Chase Michaels

"Ragdyer" wrote in message
...
So you don't have to re-invent the wheel, I've made up a couple of sheets
that the girls in the office use every Monday, to enter time card data
and
calculate the previous week's payroll.
It's set for California rules.

If you're interested, send me an e-mail with an address where you'd like
me to e-mail you a copy.

Just cut out cutout from my address.

Regards,

RD

< wrote in message
...
I have the first 5 days. I need the 6th and 7th day.

If they have less than 40 regular hour on the sixth day, then its
regular
up
until 40 then 1.5x. Same thing applies to the seventh day 48 hours. A
work
day consists of at least 8 hours.

One and one-half times the employee's regular rate or pay for all hours
worked in excess of eight hours up to and including 12 hours in any
workday,
and for the first eight hours worked on the seventh consecutive day of
work
in a workweek; and
Double the employee's regular rate or pay for all hours worked in excess
of
12 hours in any workday and for all hours worked in excess of eight on
the
seventh consecutive day of work in a workweek.

Start Lunch End Total Reg 1.5x 2x

Sun 6 1 18 11 8 3
Mon 6 1 22.5 15.5 8 4 1.5
tue soso
wed soso
thur soso
fri (here is where I need help)
sat (and here)


I am using fractions ie (17.25= 5:15 pm) not hours. If someone has this
it
would help me out so much.

Thank you in advance

Chase Michaels