# driver hour compliance formula mto

1. ## driver hour compliance formula mto

I need a formula for excel that will add each seven day period up, and give
me the total for each seven day period. for example, a driver is not allowed
to work for more than 60 hour during any 7 day period. therefore, in case of
audit, i need to have the total for each 7 period continuously without having
to adjust the formula(which would thereby erase the result and defeat the
purpose.) so in simple terms, i need to calculate days 1-7, 2-8, 3-9,
4-10,5-11 etc. the important thing is that all the results are displayed, so
that i know that they are under 60 hours

2. ## driver hour compliance formula mto

Hi!

This all depends on your layout. Post a sample of your
data with explicit details.

It could be as easy as this (but something tells me it
won't be!)

If your times are in the range A1:A100. In B7 enter this
formula and copy down:

=SUM(OFFSET(A7,0,0,-7,1))

Biff

>-----Original Message-----
>I need a formula for excel that will add each seven day

period up, and give
>me the total for each seven day period. for example, a

driver is not allowed
>to work for more than 60 hour during any 7 day period.

therefore, in case of
>audit, i need to have the total for each 7 period

continuously without having
>to adjust the formula(which would thereby erase the

result and defeat the
>purpose.) so in simple terms, i need to calculate days 1-

7, 2-8, 3-9,
>4-10,5-11 etc. the important thing is that all the

results are displayed, so
>that i know that they are under 60 hours
>.
>

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1