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?

in vba or on the worksheet?

It is 01:15 here and I need my sleep but a few pointers:
a date and time is a floating point number. The integer part is the
number of days from 1-jan-1900 and the fractional part is a fraction of
one day so 2.5 is 3jan1900 12:00

to add 12 hours add 0.5 to add 2 days add 2

08:00 is 8/24 and 16:30 is 16.5/24

If you want it on the worksheet I would probably use a user defined
function so that I could write the code in VBA

regards.

Wrote:
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?


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=540499