Request for Formula Help

Greetings,

I am using Microsoft Excell on a Mac computer, Excel version 16.65. I need a formula that extracts from column F, Visits to Patients Per Shift, and represent that result in a pie chart and a bar graph. Column F describes the date and time of each Chaplain visit per patient. Please note that column F is the result in another spreadsheet from a report that I do not have the option to change or separate.

For purposes of this formula, our shifts are defined as follows.
1st Shift: 12:30 AM — 8:30 AM
2nd Shift: 8:30 AM — 4:30 PM
3rd Shift: 4:30 PM — 12:30 AM

Thank you, with blessings, Richard