End Date/Time adding business hours
On 26/04/2012 2:47 AM, laya1024 wrote:
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
|