From date and secs, in defined day/time, calculate exact end task

Hello,
after two days of searching and testing, I'm still at the starting point, please, could you help me to find the right solution?

I searched all over the forum but there is nothing that matches.

The problem:
From a date to be entered (dd: mm: yy (cell B2)) and (hh: mm: ss (cell C2)), I have 1407000sec (cell D2) (this time is generated by other calculations) to perform a task.

The task can be performed 7/7 but from 10:00 to 00:00. (24h time format)

Desired result:
1) turn my known second in format dd: hh: mm: ss (cell D3) knowing that the working time / day is 14 hours (7/7 from 10:00 to 0:00) to know how much time the task will occupy.

2) To know the exact date (dd: mm: yy (cell B3)) and the exact time of end (hh: mm: ss (cell C3)) of the task.

Thank you in advance for your kind heart.

Lorenzo

Try

=INT(B2+C2+D2/24/6060)

and
=MOD(B2+C2+D2/24/6060,1)

Thanks Sir,it seems that it does not work. Requires perhaps a Euclidean formula.

Perhaps it needs an explanation as to in what way it does not work.

Bob Phillips said:

Perhaps it needs an explanation as to in what way it does not work.

Click to expand...

I don't know why Sir, but I know that result for first is: #NOM?
and for second is: Formula contain errors
Thanks

So what made you say maybe it should be Euclidean?

Sounds like you have a non-English version of Excel, so the function names are different.

If it is French as I would guess, you could try

=ENT(B2+C2+D2/24/6060)

and

=MOD(B2+C2+D2/24/6060;1)

Bob Phillips said:

So what made you say maybe it should be Euclidean?

Sounds like you have a non-English version of Excel, so the function names are different.

If it is French as I would guess, you could try

=ENT(B2+C2+D2/24/6060)

and

=MOD(B2+C2+D2/24/6060;1)

Click to expand...

Ah! this is good Sir, thanks a lot for your help.