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

1. ## 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.

Lorenzo

2. Try

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

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

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

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

5. Originally Posted by Bob Phillips
Perhaps it needs an explanation as to in what way it does not work.
I don't know why Sir, but I know that result for first is: #NOM?
and for second is: Formula contain errors
Thanks

6. 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)

7. Originally Posted by Bob Phillips
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)
Ah! this is good Sir, thanks a lot for your help.