Hello masters !!
Ok I've been struggling with this and it might be very simple
The formula or vba code that im trying to figure out should
Search for Agent Name ( A:A ) if the agent had a start time that is equal or larger than G1 but equal or lower than H1 time, then the formula should sum column D
tl;dr
Sum the seconds the agent was offline at a particular time
Hyper Thank you for your time !
Ok I've been struggling with this and it might be very simple
The formula or vba code that im trying to figure out should
Search for Agent Name ( A:A ) if the agent had a start time that is equal or larger than G1 but equal or lower than H1 time, then the formula should sum column D
tl;dr
Sum the seconds the agent was offline at a particular time
Hyper Thank you for your time !