Hello everyone

I've uploaded an Excel file where I need some professional help.. Unfortunately in the german msofficeforums I couldn't receive an account verification email and couldn't contact an Administrator either so here I am.

What I need:



In the Excel file you can see "Total Rückerstattungen", These are the fields where the formulas belong. The formula must be able to calculate refunds. One refund is:

Being away from work over lunch, dinner and over night
Being away from work over dinner, over night and over lunch the next day
Being away from work over night and over lunch, dinner the next day

So you always have 3 possibilities, either you miss all 3 (row 24, 25, 26) on one day, or 26 the day before and 25, 26 the next day and so on.. I've included comments in the file itself so it's easier to understand.

The refund is always bound to being away over night + 2 Meals, so the formula itself should refer to the field under "night" (row 26)

If anybody could help me, I'd be really thankful as I have no idea where to start and what to do...

If you have questions please ask. I'm not sure if I explained good enough.

Attached Files

Vorlage Präsenzerefassung 2018.xlsx (283.3 KB, 14 views)