The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » microsoft excel training day courses near kent - Tea Timer

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

microsoft excel training day courses near kent - Tea Timer

Resolved · Low Priority · Version Standard

ReplyThu 10 Jan 2008, 11:43Delegate Camil said...

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

For upcoming training course dates see: Pricing & availability

ReplyFri 18 Jan 2008, 13:17Trainer Rajeev said...

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

Excel articles

· Creating Error Alerts In Excel Using Data Validation
· How to Create Better Excel Spreadsheets: Part Four
· Special Characters in Excel
· A Brief Glimpse At Excel's What If Analyses Tools
· Say It With Ribbon

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips

How Effective Delegation Can Help Your Business Flourish

If you've built a business from nothing, it isn't always easy to trust colleagues to look after key decisions and address the issues you've been used to addressing. However, success can mean that the organisation's demands become too great for a single individual to play this role and future success can often depend on confident and effective delegation.

» Article: Delegate to succeed

How many pins can you put in Word on Documents that you use often?

» Forum post: Pin

Rather than using insert / files, have both presentations open.
1. Windows / arrange all
2. In the Slide view drag the slide you want to copy, and drop it in the other slide view.
3. Then use the smart tag to decide if you keep the formatting.