i have a spreadsheet. Column A is categorical, Mr smith or Mr jones. Column B contains date and time (one field) across a single week.

Id like to create a field showing the timings of events by each person across the week.

In addition, Id like to categorise the date and time field to hourly intervals, then replot the figure showing number of events per interval for each person.

many thanks

N