Need to measure amount of hours from two schedule tables

[bryanalmeida525]

Hello Everyone, 

I am trying to measure amount of working time based on a certain schedule to determine how many overtime hours were worked each employee ID. 

What I have is a certain ID set with a start and end time. I also have a schedule set with amount of overtime hours based on the ID's location of EC or WC. I would like to have the sum of the amount of hours that was worked in overtime between the two dates base don the Employee's ID location. 

I am not sure if a master calendar would help me, or a certain loop. Please note that this is a small sample size and will be running this for thousands of rows. 

I appreciate any feedback and assistance. 

[Brett_Bleess]

This is a duplicate post, see the following link for prior thread and post there, new posts will be blocked on this thread...

https://community.qlik.com/t5/New-to-QlikView/Need-to-Measure-amount-of-Hours-from-two-schedule-tabl...

Regards,
Brett