User Profile
Richard_James
Brass Contributor
Joined 7 years ago
User Widgets
Recent Discussions
- 3.5KViews0likes5Comments
Re: Chaplain Visits Per Shift
mathetes Formula Help with Counting Chaplain Visits Over Three Shifts Per Day The Date and Time column E is the record of the Progress Note. My question is, ”What is the formula to calculate in Excel version 16.65 to get the number of Chaplain Visits occurrences Per Shift if shifts are defined as 1st Shift: 12:00 AM to 8:00 AM, 2nd Shift: 8:00 AM to 4:00 PM, and 3rd Shift: 4:00 PM to 12:00 AM.” I also want to represent that result in a pie chart. 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. In other words, how many times did Chaplains file a Progress Note during the 1st Shift: between 12:00 AM to 8:00 AM, the 2nd Shift: between 8:00 AM to 4:00 PM, and the 3rd Shift: between 4:00 PM to 12:00 AM.? Thanks for your advisement.3.5KViews0likes9Comments- 3.5KViews0likes7Comments
Formula Help with Counting Chaplain Visits Over Three Shifts Per Day
The Date and Time column E is the record of the Progress Note. My question is, ”What is the formula to calculate in Excel version 16.65 to get the number of Chaplain Visits occurrences Per Shift if shifts are defined as 1st Shift: 12:00 AM to 8:00 AM, 2nd Shift: 8:00 AM to 4:00 PM, and 3rd Shift: 4:00 PM to 12:00 AM.” I also want to represent that result in a pie chart. 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. In other words, how many times did Chaplains file a Progress Note during the 1st Shift: between 12:00 AM to 8:00 AM, the 2nd Shift: between 8:00 AM to 4:00 PM, and the 3rd Shift: between 4:00 PM to 12:00 AM.?646Views0likes2CommentsChaplain Visits Per Shift
Greetings, 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, Richard3.8KViews0likes11CommentsRequest 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, Richard585Views0likes0Comments- 1.6KViews0likes0Comments
Re: Date Error in Feb 2020
SergeiBaklan As you know, I am using Microsoft Excell on a Mac computer. I have created the attached 4 Week Microsoft Excell Spreadsheet Calendar Template, which includes calendar dates. I use the calendar repetitively as a template. Question One: Once I get everything set up the way I want it, I would like to know how do I protect the format so that cell sizes and boarders cannot be changed but would allow my secretary to input data (names) into the cells? Question Two: Notice in cells A1 and A16 that they are grammatically incorrect, i.e., “4rd” and “1rd”. What do I need to do to the formulas in A1, A16, A31, and A46 to a sure that It will return the creamer correct grammatical statement, i.e., “1st”, “2nd”, “3rd”, “4th”, regardless where any particular week shows up?4.6KViews0likes0CommentsQuestion One: Protect Format & Two: Formula
I am using Microsoft Excell on a Mac computer. I have created the attached 4 Week Microsoft Excell Spreadsheet Calendar Template, which includes calendar dates. I use the calendar repetitively as a template. Question One: Once I get everything set up the way I want it, I would like to know how do I protect the format so that cell sizes and boarders cannot be changed but would allow my secretary to input data (names) into the cells? Question Two: Notice in cells A1 and A16 that they are grammatically incorrect i.e., “4rd” and “1rd”. What do I need to do to the formulas in A1, A16, A31, and A46 to a sure that It will return the creamer correct grammatical statement i.e. “1st”, “2nd”, “3rd”, “4th”, regardless where any particular week shows up?1.3KViews0likes4CommentsExcell Format Protection and Formula Question.
As you know, I am using Microsoft Excell on a Mac computer. I have created the attached 4 Week Microsoft Excell Spreadsheet Calendar Template, which includes calendar dates. I use the calendar repetitively as a template. Question One: Once I get everything set up the way I want it, I would like to know how do I protect the format so that cell sizes and boarders cannot be changed but would allow my secretary to input data (names) into the cells? Question Two: Notice in cells A1 and A16 that they are grammatically incorrect i.e., “4rd” and “1rd”. What do I need to do to the formulas in A1, A16, A31, and A46 to a sure that It will return the creamer correct grammatical statement i.e. “1st”, “2nd”, “3rd”, “4th”, regardless where any particular week shows up?Solved1.8KViews0likes4CommentsRe: Calculate 1st Sun, 2nd Sun, 3rd Sun, 4th Sun, and 5th Sun
Richard_James As you know, I am using Microsoft Excell on a Mac computer. I have created the attached 4 Week Microsoft Excell Spreadsheet Calendar Template, which includes calendar dates. I use the calendar repetitively as a template. Question One: Once I get everything set up the way I want it, I would like to know how do I protect the format so that cell sizes and boarders cannot be changed but would allow my secretary to input data (names) into the cells? Question Two: Notice in cells A1 and A16 that they are grammatically incorrect i.e., “4rd” and “1rd”. What do I need to do to the formulas in A1, A16, A31, and A46 to a sure that It will return the creamer correct grammatical statement i.e. “1st”, “2nd”, “3rd”, “4th”, regardless where any particular week shows up?3.1KViews0likes0Comments- 4.7KViews0likes2Comments
Re: Date Error in Feb 2020
It would be nice to start week one on Sunday, February 17, 2020. However, the reality is that Sunday we one is actually February 16, 2020. Therefore, I must start Sunday of Week 1 as February 16, 2020. Furthermore, because there are 29 days in February of 2020 (instead of the usual 28 days) there must be something wrong with the formula. Please advise.4.8KViews0likes5CommentsRe: Date Error in Feb 2020
It would be nice to start week one on Sunday, February 17, 2020. However, the reality is that Sunday we one is actually February 16, 2020. Therefore, I must start Sunday of Week 1 as February 16, 2020. Furthermore, because there are 29 days in February of 2020 (instead of the usual 28 days) there must be something wrong with the formula. Please advise.4.8KViews0likes7CommentsRe: Date Error in Feb 2020
SergeiBaklan There are 29 days in February 2020 (not 28 Days). The 29th of Feb. should fall on Saturday, and the 1st of Mar. should fall on Sunday. In other words, there is an extra day in February 2020In other words there is an extra day in February 2020.4.9KViews0likes10Comments
Recent Blog Articles
No content to show