Forum Discussion

Richard_James's avatar
Richard_James
Brass Contributor
May 02, 2023

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

No RepliesBe the first to reply

Resources