When you have two points in time and you want to calculate the amount of time elapsed, then you will need to use Excel´s TEXT function

Sometimes data gets dumped into Excel with the following date & time format:

24/01/2015  19:48:00.

Using the TEXT function and entering a special text string can give you the time elapsed in Days, Hours, Minutes and Hours & Minutes.

See below how easy this is to implement.


Text - Elapsed Time




If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Two Way Lookup Using The SUM Intersect Function There are various lookup functions that bring back values from a range of data like the VLOOKUP, INDEX, INDEX-MATCH and OFFSET functions, just to name a few.There is another lookup formula that you can use that will return the intersection of two Named Ranges!This is done...
Free Excel Formulas & Functions Webinar Train... In this popular Free Excel Formulas & Functions Webinar Training which goes for 60 minutes you will learn the MUST KNOW Excel Formulas to ADVANCE your Excel skills!You will learn the following Excel Formulas & Functions: IF, SUMIF, VLOOKUP, INDEX/MATCH + MORE...!P...
RANDBETWEEN Function I use the RANDBETWEEN function all the time whenever I need to create a sample data set.The cool thing about the RANDBETWEEN function is that if you don't like the numbers that it has given you, you can press F9 in a cell and it will give you new numbers.  Try it out by downl...
How to Convert Formulas to Values  Have you ever had a scenario where you write a formula and just want to show the value output only and get rid of the formula?Here is an example of a formula: Well I do not need the formula, bit I do want the last names only....hard copied!Fortu...