End Date/Time adding business hours

L

laya1024

Hello

I have a field with a start date and time (example 4/25/2012 11:00 am)
I would like to add business hours to determine the ending business dat
and time

Continuing with example, Business hours are 7am - 8pm.
I need 10 hours from Cell a1 start date/time 4/25/2012 11:00 am to giv
me end date/time 4/26/2012 8:00 a

My worksheet layou
Start Date time - Cell a
Business hours to add - Cell b1
End Date time - cell c

I would love it if someone could help. thanks in advance
 
V

Vacuum Sealed

Hello.

I have a field with a start date and time (example 4/25/2012 11:00 am).
I would like to add business hours to determine the ending business date
and time.

Continuing with example, Business hours are 7am - 8pm.
I need 10 hours from Cell a1 start date/time 4/25/2012 11:00 am to give
me end date/time 4/26/2012 8:00 am

My worksheet layout
Start Date time - Cell a1
Business hours to add - Cell b1
End Date time - cell c1

I would love it if someone could help. thanks in advance.
Select A1.

RightClick -> Format Cells -> Custom.

Just under the Title Type: type the following:

m/dd/yyyy hh:mm AM/PM -> Click OK

You can drop the AM/PM if you want 24 hour time format instead of 12.

Copy A1 to C1.


Select B1.

RightClick -> Format Cells -> Time -> Select h:mm:ss PM



In C1 type the following:

=IF($A1="","",$A1+$B1)

Copy down to your desired amount of rows

HTH
Mick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top