Function for considering time active and inactive

Hello,    Would anyone be able to assist me with my issue? I have four columns of data that looks like the below picture.   I am trying to show a table as follows using this data (note that c...