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