How do I add 12 business hours to the current date/time?

A

adrianbarnes.com

Business hours is defined as Monday to Friday, 8:00am - 4:30pm.

I want to add 12 business hours to the current time (09/05/2006 9:13pm)
and return the due date for completion (11/05/2006 11:30am).

Anyone help me?
 

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

Similar Threads

End Date/Time adding business hours 1
Add time when working 3rd shift 0
How to calculate difference between two date & time along with working hours and days 2
How do I count the number of blank cells 0
using a time format in a count function 1
Calculating the difference, in hours, between two date/time in two different time zon 2
Need formula for time between two events 5
Time and the Max Function 15

Top