+ Reply to Thread
Results 1 to 5 of 5

How to calculate Time Left (remaining time) using percentage

  1. #1
    Forum Contributor
    Join Date
    04-13-2017
    Location
    Buchares
    MS-Off Ver
    2016
    Posts
    117

    How to calculate Time Left (remaining time) using percentage

    Hey guys i'm having problems creating a result that displays me the estimated time left until my script is completed

    the basics :
    It's a simple script with a for from 1 to N rows
    I've made a percent calculator in order to see where I am.

    in order to the the code about how long it will take to finish i'm using the following code :

    Please Login or Register  to view this content.
    Estimates between different PC finish time : 130 seconds and 180 seconds.

    My purpose is to display using the
    Please Login or Register  to view this content.
    The estimated time left should be calculated on the speed of the percentage ?

    Something like WinRAR?

    Thank you

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: How to calculate Time Left (remaining time) using percentage

    Why not just set start time inside loop and finish time just before you move on to next iteration?

    That way it gives time for each iteration. You multiply that by # of iteration remaining and gives estimate of time remaining.

    Of course, any sort of remaining time estimate won't be anywhere near accurate (as you probably noticed using WinRar )
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    04-13-2017
    Location
    Buchares
    MS-Off Ver
    2016
    Posts
    117

    Re: How to calculate Time Left (remaining time) using percentage

    CK76, i've noticed that estimate won't be anywhere near accurate as winrar

    As for the rest, i dont know how to add or what to add as a formula to have the expected result

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: How to calculate Time Left (remaining time) using percentage

    So let's say you have loop.

    Please Login or Register  to view this content.
    You will need something like below.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    04-13-2017
    Location
    Buchares
    MS-Off Ver
    2016
    Posts
    117

    Re: How to calculate Time Left (remaining time) using percentage

    perfect ! thanks !

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to calculate percentage remaining
    By ashley01283 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-10-2021, 05:16 PM
  2. [SOLVED] Calculate time remaining
    By WendyvdV in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-27-2015, 08:44 AM
  3. [SOLVED] Calculate time remaining based on end date & time and current date
    By Kaz09 in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 08-19-2014, 07:11 AM
  4. Progress bar to show both percentage completion and time left
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-28-2014, 04:29 PM
  5. Calculate Remaining Days left Using TODAY
    By lewisale in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-22-2013, 11:12 PM
  6. Replies: 30
    Last Post: 11-14-2012, 09:39 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1