Camil has attended:
Excel Intermediate course
Tea Timer
I've been trying to work out an accurate way displaying time remaining.
At the moment I tend to use a basic implementation which looks at how long it took to complete the last cycle through a loop, and depending on the size of the precentage, a time is worked out.
This is accurate for that last step but not for the overall loop.
I was wondering if there was a better way to do this?
Thanks
RE: Tea Timer
Dear Camil
I am not sure if you are asking a question relating to VBA or just a simple time calculation.
I would like a bit of more information to understand what is it that you want to achieve.
I am going to give you a general understanding of how Excel calculates time and also some things you have to keep in mind when you are performing such calculations.
When you insert a time for purpouse of calculation Excel converts it into a decimal no. So although for you 00:00:00 might be Midnight with 0 seconds but for Excel it is simply 0.0 and 23:59:59 is .999999.
All the times are between .0 and .999999.
How to Work with Time Formulas
How to Calculate Elapsed Time
Please refer to the Excel file that I have uploaded for the following explanation.
Cell A2 and B2 have time entered in them.
In Cell C2 and D2 the formula is exactly the same i.e. =B2-A2. You can see that C2 is displaying the result in Decimal format which is general Format from the Format > Cells
