total real production time based on starttime and endtime

[MatthijsOFG]

Hello!

I have production data like this: 

How would you calculate using dax or mcode the total real time that production was running on a certain day? So in this case, 13:42:56 - 05:30:00 - gaps in production. The gaps make it hard, because I can't just simply do (maxtime of the day - mintime of the day) using ALLEXCEPT function. 

I appreciate the help ! 🙂

[MatthijsOFG]

@amitchandak 

Thank you for helping!

Because I want to know the time that total production was active. 

For example if on a certain day there are 10 production lines. The 10 production lines are all running simultaneously from 06:00 tot 07:00. I would have 10 rows of data. Your measure would answer 10 hours. But the answer I want to get out of the measure would be 1 hour. 

[amitchandak]

@MatthijsOFG , why do not you just take diff in column

Production Duration = [End Time] - [Start Time]

or have a measure like

Production Sec sum= Sumx( Table, datediff( [Start Time],[End Time] , second) )

and then covert to time

a new measure = time(0,0,0) + [Production Sec sum]/(3600*24)