LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
No Name
 
Posts: n/a
Default calculating calif overtime

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

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculating overtime Chase Michaels New Users to Excel 1 May 16th 07 04:43 PM
Calculating overtime bunnyc Excel Discussion (Misc queries) 1 February 21st 06 12:36 AM
Calculating Overtime sam13484 via OfficeKB.com Excel Worksheet Functions 1 February 3rd 06 03:20 PM
Need help calculating overtime to date BVHis Excel Worksheet Functions 8 January 9th 06 05:59 PM
Calculating overtime jennerifw New Users to Excel 3 August 9th 05 08:33 PM


All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"