Join Early Retirement Today
Thread Tools Search this Thread Display Modes
CA overtime xls spreadsheet
Old 02-08-2015, 04:34 PM   #1
Dryer sheet wannabe
Join Date: Dec 2014
Location: NorCal
Posts: 10
CA overtime xls spreadsheet

Need some help. Does anyone have an excel spreadsheet (or website) that can calculate overtime pay using California overtime rules (not FLSA) when there are two different pay rates, (ie. travel and labor paid at different rates). It's pretty straight forward when there is only one pay rate but not so simple when there are two rates. Pay period is Sunday through Saturday. For example, I'm trying to figure out what the correct pay should be for the following:
Sun - 5.25 hrs travel, Mon - 1.5 hr travel & 11 hr labor, Tues - 1 hr travel & 9.5 hr labor, Wed - 1.5 hrs travel & 10 hrs labor, Thurs - 1 hr travel, 9 hrs labor, Fri - 1.25 travel, 5 hrs labor, Sat - 6.75 travel.

Assume labor rate is paid at $30/hr and travel is paid at $15/hr. My calculations show it should be $2041.38 but not sure if that is correct.

CA overtime rules are as follows:

  • 1.5 x for hours worked after 8 hours per day and up to and including 12 hours per day, and
  • Double time for hours worked after 12 hours per day, and
  • Overtime for hours worked after 40 straight time hours per week, and
  • Applying 7th day rules, on the seventh consecutive day of work in a single work week,
    • Overtime for the first 8 hours worked, and
    • Double time for any additional hours more than 8 on the 7th day.
bumtrader is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Overtime is unhealthy Meadbh Health and Early Retirement 21 05-20-2010 02:36 AM
Tracking basis with spreadsheet, how to structure the spreadsheet? bamsphd FIRE and Money 13 08-03-2009 09:31 AM
Overtime for Exempt Employees?!? FUEGO FIRE and Money 49 08-24-2008 08:17 AM
Ahem: Navy 46, Notre Dame 44, triple overtime. Nords Other topics 5 11-04-2007 07:13 PM
Can you allow XLS attachments please? :) Peaceful_Warrior Forum Admin 3 05-10-2007 06:54 PM


All times are GMT -6. The time now is 05:42 PM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.