https://community.qlik.com/t5/QlikView/Calculate-Worktime-Costs-with-changing-tariffs/m-p/1816014#M1213023 <P>Dear QlikView-Community,&nbsp;</P><P>I am looking for a solution regarding the following problem/issue:&nbsp;</P><P>I need to calculate costs for working-assignments. I got the start- and enddate, and I know, how much is charged for which hour (e.g. MO-FR, 08.00 - 18.00: 100$/hour, MO-SO, 22:00 - 06:00: 120 $/hour, remaining: 110 $/hour);&nbsp;<BR /><BR />How could i accmplish this in Qlik?<BR />Should i split every working-hour into minutes (with iterNo() - so i could match a tariff (tariff/60) to each minute? Or is there a simpler approach?&nbsp;<BR /><BR />Greetings<BR />Jakob</P> Fri, 18 Jun 2021 08:37:18 GMT jakobjosef 2021-06-18T08:37:18Z https://community.qlik.com/t5/QlikView/Calculate-Worktime-Costs-with-changing-tariffs/m-p/1816014#M1213023 <P>Dear QlikView-Community,&nbsp;</P><P>I am looking for a solution regarding the following problem/issue:&nbsp;</P><P>I need to calculate costs for working-assignments. I got the start- and enddate, and I know, how much is charged for which hour (e.g. MO-FR, 08.00 - 18.00: 100$/hour, MO-SO, 22:00 - 06:00: 120 $/hour, remaining: 110 $/hour);&nbsp;<BR /><BR />How could i accmplish this in Qlik?<BR />Should i split every working-hour into minutes (with iterNo() - so i could match a tariff (tariff/60) to each minute? Or is there a simpler approach?&nbsp;<BR /><BR />Greetings<BR />Jakob</P> Fri, 18 Jun 2021 08:37:18 GMT https://community.qlik.com/t5/QlikView/Calculate-Worktime-Costs-with-changing-tariffs/m-p/1816014#M1213023 jakobjosef 2021-06-18T08:37:18Z