Thread: How do I add 12 business hours to the current date/time?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default How do I add 12 business hours to the current date/time?
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?

Reply With QuoteReply With Quote