Calculate future working date and time

paqcom5

New Member
Joined
Mar 29, 2010
Messages
1
My worksheet includes the ff:
E11: 0.0416666666666667 (in days) --> basically, this is 1 hour
F11: Start Date/Time (3/24/10 4:50PM)
G11: End Date/Time

What I would like to happen is to add E11 to F11 taking into account that it should only add working days and working hours (8:00AM to 5:00PM). So from my example, since I want to add an hour in the start date and time, the end date/time should be 3/25/10 8:50AM.

E11 is changing depending on the activity. Some activities take only 5 mins, some 16 days. Because of that, I chose to convert them to days to have uniformity in computing. Please help. Thanks.
 

Forum statistics

Threads
1,085,495
Messages
5,384,007
Members
401,871
Latest member
allemandi

Some videos you may like

This Week's Hot Topics

Top