How do you count occurances of something over a period of time?

[Claudius02]

I have a spread sheet with the following columns:

User name	Date	Time	Time of Day	Error Code	Status
John Doe	11/1/2016	12:25:01	AM	123	Success
John Doe	11/1/2016	8:25:00	PM	123	Success
Jane Doe	11/1/2017	8:25:00	AM	234	Failure

<tbody>
</tbody>

So I want to count how many times during a specific time period John Doe, Jane Doe, or another person used something. So, for example how many times a person used something for a 24 hour period, or used it during a month, day, year, etc.

Another issue would be how many times the status over a specific time period was a success, or failure.

EDIT:
the specific time periods would be 24 hours, week, month, year

 

[Joe4]

Welcome to the Board!

Take a look at using the COUNTIFS formula, which allows you to count records meeting certain criteria.
See here for an example on how to do a date/time range: https://exceljet.net/formula/count-cells-between-dates
To add the person, just add another set of criteria (which name range and name value).