Per diems, First and last day policy.

Hello all,

we have a requirement for Expense per diems to calculate rate for first and last day as follow based on a daily rate:

a) up to 8 hours - 1/3 allowance is payable,
b) over 8 to 12 hours - 50% of the allowance is payable,
c) more than 12 hours - full allowance is payable.

System shows first and last day but when I set it up it doesn't work as expected.

Here is an extract of the setup:

Can anyone help on this?

Thanks in advance.

Kind regards,

Eva