LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Trying to excel in life but need help
 
Posts: n/a
Default Need a formula for this problem

I am designing a spreadsheet in Excel and I need to track employee hours
using the following conditions. I already have a worsheet for each week
totaling the hours each day. I need a formula that would account for an
employee working more than 60 hours in any consecutive 7 day period. There
is also a 70 hr/ 8 day rule and a 120 hour/ 14 day rule. as outlined below.

A driver my not drive a truck or bus after having been on duty for,
a) 60 hours in 7 consecutive days, without having 8 hours off, or
b) 70 hours in 8 consecutive days, or
c) 120 hours in 14 consecutive days

Please help,
Thank you in advance.
Martin



 
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
revert formula insertion to old method Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 01:49 PM
Formula Problem J.C.De New Users to Excel 1 January 21st 05 04:22 PM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM
Baffling formula problem Ken Schmidt Excel Discussion (Misc queries) 2 December 21st 04 07:52 AM
Formula Problem Tracey BVS Excel Discussion (Misc queries) 2 December 9th 04 11:50 AM


All times are GMT +1. The time now is 01:33 AM.

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"