I do staff time tracking.

Everyday, each staff can do any time range.

Until 22:00 we pay Tariff A.

After 22:00 we pay Tariff B.

How to tell Ninox: "from the time range he did, there are only THIS AMOUNT OF HOURS up to 22:00... and the rest of hours are after 22:00" so can multiply by each Tariff in each case?

Example:

Staff IN: 17:00

Staff OUT: 23:30

HOURS: 6:30

I need a calculation to get: 5 hours up to 22:00 (in 'Day Tariff Hours' field)... and... 1:30 hours after 22:00 (in 'Night Tariff Hours' field).