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 |
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 . |
All times are GMT +1. The time now is 10:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com