Calculate between two times (2)

Using TEXT formula to calculate time. 


Use =TEXT(End time-Start time,"format to use") to calculate between two times. Simply replace the format to use with:

h = hour

mm = minutes

ss = seconds.


Example:


The result would be,



You can also personalize the formula.


This will return the result based on each preference.



Labels: ,

Shortcut to use in Microsoft Office 1

There are shortcuts that you can use in Microsoft Office to fasten your work. You need to press the same keys together. 1) Ctrl + A - to sel...

  • MIN
     Formula MIN is used to search the least value. Example of formula is =MIN(RANGE X:RANGE Y) Example 1 : To find the minimum value of a row ...
  • AVE
    Formula  AVERAGE  is used to search the average value. Example of formula  is  =AVERAGE(RANGE X:RANGE Y) Example 1 : To find the average val...
  • Using '&' in Microsoft Excel
    To connect strings in Microsoft Excel, simply use '&'.   Example : This will return the following results: