Hi Guys
I am in Need to plan travel time as average based on an amount of days spending onsite at the customer.
In Detail: For every <=40 hours I Need write 4 hours in a separate cell.
So when someone spends 24 hours at the customer (less than a week) I want the fomula to write "4" into a cell.
If a Consultant spend 200 hours (5 weeks f work, base don 8 hours a day), I Need 40 (5x8) in that cell.
MAybe I just Need a break, but I dont find a solution for that.
I am in Need to plan travel time as average based on an amount of days spending onsite at the customer.
In Detail: For every <=40 hours I Need write 4 hours in a separate cell.
So when someone spends 24 hours at the customer (less than a week) I want the fomula to write "4" into a cell.
If a Consultant spend 200 hours (5 weeks f work, base don 8 hours a day), I Need 40 (5x8) in that cell.
MAybe I just Need a break, but I dont find a solution for that.