Query - Counting frequency of a specific time in column

[graemekoz]

I am using Excel to create staffing rosters and I'm trying to see if there is a function in Excel which will allow me to calculate how many staff are starting at specific times. The Rosters are going to change each time so is there a way of doing this without having to manually request the information?

For example, each start time of the staff is calculated by formula at the top of the spreadsheet. Some staff start later than others. I want to be able to get a list which states how many times a specific start time appears in the list.

I hope that makes sense and any assistance would be greatly appreciated!

Graeme

 

[etaf]

you could probably use countif()

do you have a cell that has what the start time should be
=COUNTIF(Range of cells with the starttime, cell with the actual expected starttime )

So if cell C1 has the calculation for what the starttime should be
then B2:B1000 has all the actual starttimes

=COUNTIF(B2:B1000,$C$1)

will count how many times in the column B have the exact same time as in cell C1