Wim Geuens
Member
Hi,
I'm trying to create a timeworksheet file with some control factors included.
One of the controls I need to submit is the following.
In each period of 7 days (doesn't need to be from Monday to Friday) the resting time should be at least 36 hours in 2 consecutive days.
Resting time per day is included, but I can't seem to find a working formula that looks in the last 7 days of the sum of adjacent cells is above 36hours.
attached is a part of my workbook
Many thanks for your help
W
I'm trying to create a timeworksheet file with some control factors included.
One of the controls I need to submit is the following.
In each period of 7 days (doesn't need to be from Monday to Friday) the resting time should be at least 36 hours in 2 consecutive days.
Resting time per day is included, but I can't seem to find a working formula that looks in the last 7 days of the sum of adjacent cells is above 36hours.
attached is a part of my workbook
Many thanks for your help
W