I was hoping for some help in regards to the following problem:
-In Column A I have names (let's say, ship names)
-In Column B I have a start time
-In Colum C I have an end time
-Column D is the total duration in hours (B1-A1) that the ship was 'active'
What I'm struggling with, is how do I calculate the number of 'active' hours during daytime - let's say between 7AM-7PM?
Appreciate any help I can get get as I've reached a mental block!