Graphs using start and end times

I have a data which has a start time, end time, Stay Time(End-Start) and # of subjects. I am trying to create a graph, line, bar or histogram which shows how many subjects were there at a specific time. So the horizontal axis would have time from 00:00 to 24:00 and vertical axis would have the total # of subjects or the %.

Start End Subject Stay
01:00 02:00 1 01:00
01:00 01:45 1 00:45
02:00 21:00 1 19:00
03:10 14:10 1 11:00
The data set is huge(27000 rows) and I am using excel to create a graph.

I have tried using line plots and bar charts(stacked) but couldn't. I am not sure if there is an easier way to do it .

Please advise.

Thanks

Maybe this is what you are looking for

Thanks RCM ! This is exactly what I am looking for. I only need to get the data in the right format as you did. I appreciate your help. Thank you.

Thanks newdoverman ! That's a good approach as well. I appreciate that.