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.

HELPFUL RESOURCE: