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.
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.
