vba-excel-training - excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba-excel-training - Excel

vba-excel-training - Excel

resolvedResolved · Low Priority · Version Standard

Edward has attended:
Excel Intermediate course

Excel

Question already posed earlier today

RE: Excel

Dear Edward

Thank you for informing us about the question that you have asked earlier.

I just wanted to clarify that if you have posted a question in the delegate support forum in the exercise that the trainer takes you through then you DO NOT have to post another question t the time when you are providing the feedback.

This is normally optional and can be left blank. It is only for those delegates who might have forgotten or may not have a question to post earlier in the day and might want to post a question right at the end of the day.

I apologise for any misunderstanding and hopefully if you do any future training with us then you'd know the procedure and would not have to put the question twice. You may even tell one of the other delegates in the course not to make the same mistake.

Thank you for your time and co-operation.

One of the trainers or I'll get back to you with an answer for the question that you have posted today!!

Kindest Regards

Rajeev Rawat

MOS master Instructor 2000 and 2003




 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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


Server loaded in 0.09 secs.