View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sewfoolish Sewfoolish is offline
external usenet poster
 
Posts: 2
Default How many hours in the last 7 days did I work?

I need help putting together a formula for these rolling time periods please.
I have hour limits on time worked. I can:
-Work no more than 16 hours straight. And,
-Work no more than 16 in any 24 hours. And
-No more than 28 in any 48 hours. And
-No more than 72 hours in 7 days. And
-At least 8 hours between shifts.
Very limiting but I've been unable to figure a formula/formulas using time
of the day you worked - or scheduled to be worked. Thanks