LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kim DuBray
 
Posts: n/a
Default More complex overtime question

Any hours past 8 in a day is paid at 1.5
Any hours past 12 is paid at 2.0, except on Sat and Sun
Any hours over 40 in a week.
On Sat (or any day in the week where 40 hrs is met) overtime is paid at 1.5.
If on Sat 40 hours is not reached, the first 8 hours are paid at 1.0 until
the 40 hours is reached. Once 40 hours is reached, hours between 8-12 are
paid at 1.5 and over 12 at 2.0. On Sun the 40 hours rule is disregarded if it
is the sixth consecutive day and the first 8 hours are paid at 1.5 and over 8
is 2.0.

I am having the most trouble with combining the 40 hour work rule and the
sixth consecutive day rule. Can anyone help with the formula's?
 
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
Complex overtime calculation Kim DuBray Excel Worksheet Functions 2 December 8th 05 12:34 AM
Overtime Question Unlike Others (Pictures Included) C A Excel Worksheet Functions 2 October 28th 05 04:48 PM
Hide Rows / Columns - complex question lw new guest Excel Worksheet Functions 2 August 18th 05 08:02 PM
Complex query question Stacy Excel Worksheet Functions 0 June 30th 05 09:50 PM
complex count question JBoulton Excel Worksheet Functions 13 March 24th 05 02:57 AM


All times are GMT +1. The time now is 02:41 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"