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

lorenzo999999

New member
Joined
Dec 17, 2012
Messages
4
Reaction score
0
Points
0
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
 

Attachments

  • timecalcul.xlsx
    9.5 KB · Views: 9

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Try

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

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

lorenzo999999

New member
Joined
Dec 17, 2012
Messages
4
Reaction score
0
Points
0
Thanks Sir,it seems that it does not work. Requires perhaps a Euclidean formula.
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Perhaps it needs an explanation as to in what way it does not work.
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
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)
 

lorenzo999999

New member
Joined
Dec 17, 2012
Messages
4
Reaction score
0
Points
0
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.
 
Top