Adding Hours to a workday

**joeinck** · 11-02-2012, 09:57 AM

Hello again,
I recently posted a challenge and got some great VBa responses, however I can not use Macros in my spreadsheets. Also, I figured out a better way to ask my question and I think I am getting closer.

Given a work day of 7:00am to 7:00pm
Given a work week of Monday thru Saturday
can the following be done in excel:

Date/time
11/3/2012 5:00pm

+ 6 (hours)

= 11/4/2012 11:00am

Thanks in advance...

**alansidman** · 11-02-2012, 10:09 AM

Firstly: 6 hours added to your value would make the answer 11/3/2012 11:00 pm
To achieve your answer, you will need to add 18 hours.

with your cells formatted as Date/Time
in the adjacent cell to A1 which holds your value type = A1 + (18/24)

Alan

**mshale** · 11-02-2012, 11:34 AM

This is the best I could come up with.
You can probably end up taking a bunch of the columns out and condensing the formulas, but I'm a bit too lazy

Originally Posted by alansidman

Firstly: 6 hours added to your value would make the answer 11/3/2012 11:00 pm
To achieve your answer, you will need to add 18 hours.

with your cells formatted as Date/Time
in the adjacent cell to A1 which holds your value type = A1 + (18/24)

Alan

He wants to incorporate 12 hour workdays. So, 11/3/2012 11:00 pm is outside of the workday, so a few hours must be carried over to the next workday.

**joeinck** · 11-04-2012, 08:17 AM

Thanks Alan,
I wish it was this easy. We have a lot of tasks to plan for when designing a building and the solution you describe would not really automate the process (we could not simply add the time required for the task, we would also have to track the end/begining effect on the the work day). MS Project does this sort of thing automatically, that is one of the nice features about it. The place I work will not provide this software so I am struggling with a work around.
thanks again,
j

**alansidman** · 11-04-2012, 08:51 AM

Joeinck--my apologies. I did not read your request clearly. I missed the part about the work day hours and days. I understand what you are looking for. It looks like MShale has provided an answer that works.

Good luck.

Alan