Excel TIme Formula - calculate from specific Range

HISergeiBaklan ,

I very much appreciate you having a look at this. 

... here  in lies the rub, I need to isolate only the hours from Midnight to 3 am from the 9pm - 3am data range. 

I am going down the path of (If) as it is the only way I see to ask excel to look specifically for times between midnight and 7am, however my knowledge of excel is not poor, it is certainly a struggle to get through this one with the conceptualisation and the syntax as well

I am thinking 'If D = 00:00 thru 07:00 then sum(00:00:00 + D3)' something to that effect would result in the 3hours that I am looking for in the example. I dont know the excel Syntax and functions well enough, and have spent hours trolling through the various Excel functions to find the concept, without even knowing if im barking up the right tree

Thanks again for your response. Any Guidance is most appreciated!

T