Calculate the duration between two times in a day in Google Sheets

Get your copy of the Google Sheet Project Task Manager here: yagisanatode.teachable.com/p/google-sheets-project-tasks-manager

Learn how to calculate the duration in hours and minutes between two times in a day in Google Sheets. I'll cover some gotchas too.

This video is part of a series in duration and time calculation so don't forget to subscript to get the next video.

Like and subscribe to find out when the next tutorial on how to import specific data with QUERY, FILTER and VLOOKUP.

Contents 00:00 Intro & Example 00:26 Headers 00:50 formatting the time cells 01:50 AM/PM vs 24hr time 02:43 formatting duration 04:07 Calculating duration

If you like the video, check out my website: https://yagisanatode.com/

Here is the link to just Google Sheets tutorials: https://yagisanatode.com/google-sheets/

Sign up for my course: Google Sheets: Learn the Essentials with Three Detailed Projects https://yagisanatode.teachable.com/p/google-sheets

Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450

#GoogleSheets #Spreadsheets #GoogleEdu #administration #GoogleWorkspace ... https://www.youtube.com/watch?v=z0NseYXLVsQ