| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract 8 business hours from a date/time value? | Excel Discussion (Misc queries) | |||
| Date and Time Response- before/during/after Business hours | Excel Discussion (Misc queries) | |||
| Add 12 business hours to Time | Excel Worksheet Functions | |||
| How do I add 12 business hours to the current date/time? | Excel Worksheet Functions | |||
| How do I add 12 business hours to the current date/time? | Excel Worksheet Functions | |||
Threaded Mode
