Evaluate the number of races per hours per hour, per day, per week and per month

[pgarcia75]

Hello

I try to analyze the service performed by stretcher bearers in a hospital.

A stretcher's race is characterized by a reference, a date and time of departure and a date and time of arrival.

I loaded a table with these 3 fields: Ref (unique reference), DateDep (date and time of departure DD / MM / YYYY HH: MM) and DateArr (date and time of arrival DD / MM / YYYY HH: MM )

I would like to evaluate the number of races per hours per hour, per day, per week and per month.

How can I do ?

Thank you for your help

Patrice

[swuehl]

Not quite sure what you mean with 'evaluate the number of races per hours per hour'. Could you elaborate?

Maybe by posting some input data and your expected result?

Maybe you are looking for something similar like

Re: How to count how many people was/are in the building??

I would start with creating records for the most granular time period (hour) for each Reference ID using a WHILE loop.

Maybe something like

Utilization per hour