Create figure of events in time

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

https://www.officetimeline.com/gantt-chart-excel will help explain the timeline or Gannt chart you can create.

The hourly time window can be done by using the below formula typed into column C which will now be your helper column. I've assumed your data has headers and the date and time values start from B2

Formula:

=TIME(HOUR(B2),0,0)

If you are looking for the full time to be taken from B2 then you can use

Formula:

 =B2-INT(B2) 

thanks
so how to graph the hours slots of a week along the X axis - and then the number of events per hour slot on the Y axis (for two people)
N