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.