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

SUMIF Function: Introduction The SUMIF function is used widely amongst spreadsheet users as it is a simple Excel function.  It allows you to Sum the values in a range that meet a criteria that you specify. So if you want to Sum a range of sales values that are above $3,000 then this is the best Excel func...
Extract Last Name with Excel’s REPLACE Formula What does it do? Replaces part of a text string, based on the number of characters you specify, with a different text string Formula breakdown: =REPLACE(old_text, start_num, num_chars, new_text) What it means: =REPLACE(this cell, starting from this number, all the ...
Getting the length of text with Excel’s LEN ... What does it do? Gives you the number of characters of the text Formula breakdown: =LEN(text) What it means: =LEN(text that you want to get the number of characters) There are times when you need to get the number of characters within a cell in Excel.  Thank...
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...