End Date/Time adding business hours
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. |
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 |
All times are GMT +1. The time now is 10:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com