I am looking to calculate the number of days requested off excluding weekends and holidays in Column C on the Requests Sheet.
In Column D on the Requests sheet I need the formula to calculate the number of work hours excluding weekends and holidays.
I have attached a copy of the excel workbook for reference.
Please tell us what your expected results are and why? What is not working with the NETWORKDAYS formula, in your opinion?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
It is not that the NETWORKDAYS that is not calculating correctly. I am having trouble getting the number of hours requested to calculate, I need it to calculate the number of hours requested for if it is over 24 hours and if it under 24 hours.
So what are your expected results for the two examples given?
If a person request 2 hours then in column D it would calculate 2 hours. But in Column C it would be zero days.Originally Posted by AliGW
No, what value do you want in cells D2 and D3 in your example worksheet, specifically?
I think it will work out to be something like:
But I will need to clarify some assumptions, particularly if you want all the hours, or just the ones in excess of a workday.
Please Login or Register to view this content.
Also looking at this, is 7:30 to 16:00 a full workday? Cuz that's a eight-and-a-half hours, which clocks as a full 8-hour day plus a half hour lunch. Do you need to chop a half-hour off your hour count because of the break time vs. PTO thing?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Please just answer the question. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks