Other Time/Percentage

Discussion in 'General' started by Ryu_ookami, 14 Jun 2009.

  1. Ryu_ookami

    Ryu_ookami I write therefore I suffer.

    Joined:
    11 Mar 2004
    Posts:
    3,373
    Likes Received:
    147
    Does anyone know of a program that will show the remaining time of a fixed time as a percentage. I know it's an odd question but its so I know how long before I need to harvest the crops on farm town. So I would need to be able to put the total growing time in then the percentage which has already completed and for the program or whatever to tell me how long is left before harvesting needs to be done..
     
  2. Fod

    Fod what is the cheesecake?

    Joined:
    26 Aug 2004
    Posts:
    5,802
    Likes Received:
    133
    er, just do it in an excel spreadsheet.
     
  3. Ryu_ookami

    Ryu_ookami I write therefore I suffer.

    Joined:
    11 Mar 2004
    Posts:
    3,373
    Likes Received:
    147
    That option is dependent on 1 or more of 3 assumations.

    1. That I have excel (luckily I have open office so I have their version)

    2. That I actually know how to use it (I know the basics)

    3. that I know the formula to use (ding...ding...ding we have a winner. I'm LOUSY at maths. I
    wouldn't even know where to start)
     
  4. ch424

    ch424 Design Warrior

    Joined:
    26 May 2004
    Posts:
    3,112
    Likes Received:
    41
    You need three or four cells:

    A1 - type in the start time (dd/mm/yy hh:mm:ss)
    A2 - type in the end time (same format)
    A3 =100*(NOW()-A1)/(A2-A1)
    A4 =100-A3

    A3 shows the percentage of time gone, A4 shows the percentage left. :)
     
  5. Ryu_ookami

    Ryu_ookami I write therefore I suffer.

    Joined:
    11 Mar 2004
    Posts:
    3,373
    Likes Received:
    147
    is there any way to show A4 as a value of time rather than a percentage so instead of it saying something like 20% left it says something like 6 hours left i.e it returns its vaue as a time if oyu get what I mean as I've not explained it very well.

    see what I was after was something like

    A1 = total growing time
    A2 = Percentage of growing time already passed
    A3 = Total growing time left.

    I've also just discovered that farm town's days are only 20 hours long if that helps any.
     
  6. Jamie

    Jamie ex-Bit-Tech code junkie

    Joined:
    12 Mar 2001
    Posts:
    8,180
    Likes Received:
    54
    I think you need to learn how to work out stuff like this, what you're asking in A3 is so simple.
     
  7. ch424

    ch424 Design Warrior

    Joined:
    26 May 2004
    Posts:
    3,112
    Likes Received:
    41
    OK, the NOW() function returns the current time. If you need any more help than that, try looking at some 11+ SATS maths text books.
     
  8. Ryu_ookami

    Ryu_ookami I write therefore I suffer.

    Joined:
    11 Mar 2004
    Posts:
    3,373
    Likes Received:
    147
    ok guys I think we have got our lines crossed somewhere. Heres what i'm doing at present

    60 (total growing hours) / 100 (to get the percentage of growth per hour) = 0.6 (1 hours growth)

    Then

    0.6(1 hours growth) * 91 (as an example if the harvest says thats it 91% done) = 54.6 (total growing time completed so far

    Heres where I'm having the problem the 54 is obviously 54 hours what I'm having the problem with is converting the 0.6 into a calculation of time as my brains gone blank every time I hit it.
     

Share This Page