Calculate the time difference between 2 given times in Excel, using the =TEXT formula.
Very useful to calculate time taken by a customer service executive to resolve an issue over phone, or time taken by a runner to complete his/her race.
Also add meaningful analysis in your data using the nested IF function and Conditional formatting.
More videos to learn Excel from
• Learn Excel's Tricks
SUBSCRIBE to Excel Rush's YouTube channel!
/ @excelrush
Blog
Visit www.ExcelRush.com for my free blog to learn Excel in-depth.