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
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