The solution provided by Daddylonglegs at the link below does not work for this particular scenario. Any help will be greatly appreciated.
excelforum.com/excel-formulas-and-functions/979700-calculating-target-date-time-based-on-start-date-and-hours-excel-2007-a.html
I'm trying to calculate enddate and time when start date and duration is provided. The solution provided by Daddylonglegs works perfectly but something goes wrong in the below scenario.
The enddate & time does not calculate correctly if the time is 2:00 PM and the duration is 4 hours. Let me explain...
StartDate&Time = 24 Sep 2:00 PM
Duration = 4 hours
WorkHours is 10:00 to 18:00
EndDate&Time shows as 25 Sep 10:00 AM instead of 24 Sep 06:00 PM
I'm racking my brains over this and can't figure out why it doesn't calculate correctly for 2:00 PM (any other time between 6-18:00 works fine). Your help will be greatly appreciated.
Bookmarks