Hi,
I am trying to output the end date using the formula workday, but I need to only include 9 AM - 6 PM working hours.
For example, if start date is 4/18/11 at 3:00 PM and the next deliverable is 2 days following, the output would be 4/20/11 at 3:00 PM.
See sample attached.
Thanks!
Hi rachaeld and welcome to the forum,
I'd like to help but don't really understand the question, and your sample is as clear as mud.
Is this the problem?
It takes 49 hours (example) to finish a product and a worker starts at 3pm on Day X. What will the date and time be when s/he finishes the product?
Is that the question?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi Marvin,
Yes, that's pretty much it. In my sample, I would want C25 to read 4/22/11 3:00 PM since it is 2 days after 4/20/11 3:00 PM but it's showing 12 AM. I also want to define that working hours are between 9:00 AM and 6 PM, assuming that the start date (C24) would be during work hours.
Hope that helps.
Hi,
My question is really almost a matter symantics. Is 2 days 48 hours? I think I'm confused on what are the given parts of the problem. Are you saying it takes (9am to 6pm) 9 hrs to equal one work day?
So you want to know the Day and Hour something is supposed to finish, given the Starting Date and hour it starts. BUT you only want to count working day hours.
Sorry I"m being dumb on this, but I hate the problem to change if I play with it.
Hi, 2 days can be 48 hours.Originally Posted by MarvinP
That's exactly it. So in my example that I attached, the first step should be done 4/22 at 3:00 PM not 12:00 AM. Since it started at 4/20/11 3:00 PM and needs 2 days to complete which i've included in the formula =WORKDAY(C24,2)
But the output itself is reverting to 12:00 AM where it should be 3:00 PM
Hi rachaeld,
I'm completely lost with your question. The possibility of a workday being from 9am to 6pm which is 9 hours and your last post that says 2 days can be 48 hours is like saying 9 = 24 and I wonder if Alzheimer's is setting in. I guess we need a smart guru to help with this problem. That would be one that understands the question.
Sorry I just don't get the question.
Hi Marvin,
You can ignore the 9-6 issue, basically all I want is if start date = 4/18/11 at 3:00 PM and end date is start date + 2 days, i want it to show 4/20/11 at 3:00 PM , not 4/20/11 at 12:00 AM as it is currently. The workday formula is great because it eliminates weekends, but it does not take time into effect.
Hi
We had a similar problem a few weeks ago. It was this problem a little backwards. It was asking how many hours were between two workdays but a extra problem of needing to deal with holidays. See if this past problem and answer solves your problem.
http://www.excelforum.com/excel-gene...c-holiday.html
We ended up with about 3 different solutions for this question with DaddyLongleggs having generalized it best.
Workdays only returns the serial number of the DAY - not the time.
edvwvw
Is there a formula that would allow the time?
Look at the formulas that were in that past thread. It worked on the time as well as the day and holidays.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks