Excel VBA certificate

Resolved · Low Priority · Version 2007

Mon 2 Apr 2012, 13:26 Delegate Lyn said...

Lyn has attended:
Excel VBA Intro Intermediate course

Excel VBA certificate

I would appreciate an attendance certificate or the VBA Excel intro course I recently attended. Many thanks Lyn

Tue 3 Apr 2012, 16:30 Trainer Yolande said...

RE: excel VBA certificate

Hi

Thanks for your certificate request, we've printed one off and it will be sent to you within a week.

Best regards

Yolande

Tue 10 Apr 2012: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips