Breach Time

[Charlz_1]

Good day,

May you please help me to measure arrival date and time against appointment date and appointment slot

AM slot is from 8am until 12pm

[Mario_De_Felipe]

Hi @Charlz_1 ,

could you bring more details about you want to calculate?

Thanks!

[petrus · Accepted solution]

Hi, if you want to know the difference between those two times (be sure it is formatted as a time) use interval function.

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/Formatt...