Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/04/Count-Unique-Values.xlsx

In this video I demonstrate how to add up times in Excel. Times are stored as numbers in Excel, so it is possible to add them up or subtract them.

Things get more involved when you add up a total of times that exceed 24 hours - this video demonstrates a formatting trick that solves this problem.

The video also explores how to calculate elapsed time across multiple days. So for example you may start a shift on Monday evening and finish it early Tuesday morning.
------------------------