If time in cell greater than current time, then count 1

[Olisthoughts]

Hi,

I'm making a break list for my team at my new job.

The employees can set a start time for their break, and an estimated return time is calculated automatically based on the break length.

I want to calculate how many agents are on break right now, based on if the estimated return time is greater than the current time. That would be an indicator that 1 agent is on break.

I just can't think of the correct formula to do this, I think the pseudo-code could be (If time in cell range is greater than current time, then sum those cells, and display currently on break"

But I can't think of a correct formula to do it.

If there are other ways to calculate currently on break that will work too.

I will attach a screenshot.

For context, I think you may be interested in knowing that there used to be 4 columns (start, estimated, actual return time, and total break time) I was using a helper column to calculate if there is a start time without a return time and that counted as 1. But my manager said she wants only the first 2 columns.

Thank you.

 

[Olisthoughts]

Another pseudo-code I was thinking of is
If current time is 30 minutes greater than start time, then 0 agents on break, else 1 agent on break