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