Results 1 to 7 of 7

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    Try

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

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

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

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

  5. #5
    Quote Originally Posted by Bob Phillips View Post
    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. #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. #7
    Quote Originally Posted by Bob Phillips View Post
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •