based on your sample one option below (which will return your expected result):
the above is an approach provided by an old poster here (daddylonglegs)Formula:
C7:
=WORKDAY($C$5,CEILING(($C$6+MOD($C$5,1)-$C$3)/($D$3-$C$3),1)-1)+MOD($C$5,1)+$C$6-CEILING(MOD($C$5,1)+$C$6-$C$3,$D$3-$C$3)+$D$3-$C$3
format as m/d h:mm:ss AM/PM
Bookmarks