Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

	98.1 % recommend us
	More live stats...

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

Training information:

Formulas

Resolved · Low Priority · Version 2003

Reply Thu 16 Apr 2009, 11:50Delegate Naseema said...

Naseema has attended:
Excel Intermediate course

Formulas

How does the formulas work on excel?

For upcoming training course dates see: Pricing & availability

Reply Fri 17 Apr 2009, 15:31Trainer Rajeev said...

RE: Formulas

Dear Naseema

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

Excel can be used to perform various formulae so I am not sure if you have any specific formula in mind or are you asking this as a general question.

If you want to know about the calculation order in Excel then please note that it follows the BODMAS.

Please refer to the following link where I have answered this question in my previous post.:

http://www.microsofttraining.net/post-17490-formula.html

Please note that you can search the forum and type the keyword to see other questions that other delegates might have asked relating to the topic that you may need help with.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Fri 24 Apr 2009: Automatically marked as resolved.

Excel articles

· Improve Performance Of Your Excel Macros
· Create Contrasting Coloured Rows In Excel
· Create Buttons To Navigate Between Worksheets
· Microsoft Excel as a Reporting Tool
· Microsoft Excel Training: Not Just for Newbies Anymore

Please browse our web site to find out more about
excel vba training course london and other Microsoft training courses.

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