Calculate start date & time of task (working hours)

You coudl perhaps try something along the lines of:

=WORKDAY($B2;-FLOOR($A2/MOD($G$1-$F$1;1);1))+$G$1-MOD($A2-(MOD($B2;1)-$G$1);$G$1-$F$1)

where

A2 holds duration (13:00)
B2 holds start date time - assumed to be within a working window (eg 16/06/2010 09:00)

F1 holds working start time (08:00)
G1 holds working end time (17:00)

You can add holiday range to WORKDAY as required

I have no doubt daddylonglegs can shorten / improve.

Incidentally based on your sample I believe end time should be 14:00 rather than 13:00 (1 hour day 1, 9 hours day 2 and 3 hours day 3)

In retrospect it doesn't work for all scenarios ... in the words of Arnie - I'll be back.

I think this works

Please Login or Register  to view this content.

A2 - duration - eg 13:00
B2 - end datetime - eg 16/06 09:00
F1 - work start time - eg 08:00
G1 - work end time - eg 17:00

However, I have no doubt (whatsoever) that the above can be condensed significantly - hopefully daddylonglegs will put me out of my misery later on today.

ded1 welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.