Calculating the duration between two dates and times in Google sheets

Find out how to get the duration in hours and minutes between two dates and times in Google Sheets.

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

Contents
00:00 Intro & Example
00:26 Pros & Cons of each approach
01:24 Dates & Times in one cell
05:57 Dates & Times in separate cells

If you like the video, check out my website:

Here is the link to just Google Sheets tutorials:

Sign up for my course:
Google Sheets: Learn the Essentials with Three Detailed Projects

Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts.

#GoogleSheets #Spreadsheets #GoogleEdu #administration #GoogleWorkspace

[Narindersingh-nsuv]

Help me there!

What's wrong with what I'm doing?

I WOULD LIKE TO SEE CHANGE FROM, FOR EXAMPLE

24-12-2022 TO 24-11-2022

ITS SHOWS 29 January 1900.

[hqw-]

How to Change formate of Duration to Elapsed Days : hours : Mins..

Instead of Hours : mins

[asokoniso]

Hi, how do I solve a problem where the sheets calculates it wrong in which the start of the work shift is at 10 pm and it ends at 2 am the next day?

[MayukhVerma]

Thanks man. I have been searching for this for so long.

[ranahassan]

Thank you that was just what I needed 🙏

[ConsciousnessExpansionSchool]

What if you want to have a cummulative overview of multiple entries and pass the 24 hr range? I cannot get the cummulative to calculate properly

[austinkieffer]

Can you show us how this would work if we wanted to create a 15 minute step in another document as a drop down menu? I know the formula is for this document but how would it work if you wanted to add the array/sequence into an already done document to create a drop down that was 15 minute increments?

[theofficeshorts]

how do I calculate or add the duration of time within a specific time period, I want to calculate pay, So I get paid a different rate between from 5am and 5pm and I get paid a different rate between 5pm and 5am night rate. could you help me with this

[chantalcarter]

wondering if there is a way to show days, hours, and mins

[temyraverdana]

Thanks, I really appreciate your tip!