Calculating the duration of time between two times is a pretty common task. From measuring how long a process took, to entering the hours you put into a project, to creating a timesheet. You will find it everywhere, so working out duration is a hand skill to have in Google Sheets.
However, there are some gotchas when calculating the duration of time. So it is worth a good looking into.
To get a feel of how calculating durations work out in the wild, you can check out the video below for a great example on how I use it to build a Project Task Google Sheets workbook.
Get your very own copy here: Project Task Manager.
In this tutorial, we will cover how to calculate the duration of time over a single day or multiple days and sum a list of durations.
I encourage you to follow along so you can create your own template copy of the Google Sheet and do a bit of practice and experimenting on your own.
Pretty much everything in this tutorial is beginner-friendly. Don’t be afraid to give it a go.