Sum by date meeting minutes between two times

[mrwiley]

Good day,

I have met my match in obtaining data between two times by date. What I need to do is by date calculate the meeting minutes between 7:30am and 5PM

I am hoping someone could help...

My formula - =SUMIFS($D:$D,$A:$A,H3,$B:$B,">"&H4,$C:$C,"<="&H5)

Column A is dates
Column B is start time
Column C is End time
Columns D is total number of mins (C2-B2)

Column H3 is date I want to calculate -
Column H4 is beginning time I need it to look for 7:30 a
Column H5 is ending time I need it to look for 5 pm

I need to know by day how many minutes were used between those times.

I used the formula above but it just isn't panning out. I even tried the Hour(H4) but no avail.

FILE - Book6.xlsx

 

[Fluff]

Change the cell format to time.

 

[mrwiley]

Change the cell format to time.

WOW! Something so simple... thanks so much

 

[Fluff]

You're welcome & thanks for the feedback.