• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding working hours to a Date time and Exclude weekends

D

DJR

New Member
Hello,
Found lots of help on formulas on here but they seem to be the reverse of what im looking for.
Im sure this isnt too complicated and I could probably reverse engineer something but thought I would ask.

The requirement is to add x hours to a date time but it needs to calculate a working day which is only 10.5 hours long and excludes weekends.

So I want to add 50 working hours to a start date/time and the result to only to count working days as Monday to Friday and working hours to be 07:30 to 18:00

So for example.
start is Thursday 6th October 08:00 plus 50 working hours would result in Wednesday 12th October 16:00


Any advice even if just point me to the right formulas.
 
Hi ,

See if this is OK.

I have assumed that the Start Date + Time will not be earlier than 07:30 or later than 18:00 , such as 6th October 9:00 PM or 6th October 2:00 AM.

Narayan
 

Attachments

You must log in or register to reply here.
Back
Top