Help with time duration equation between two dates/times

I have two date/time columns and need an equation to extract the duration in hours/minutes. I’d do it on the Google Sheet but new submissions create a new row so any formula on the sheet does not apply to new rows. Screen Shot 2020-07-20 at 9.48.07 AM|300x209

1 Like

You can use this.

2 Likes

I was doing the same today. Check below to calculate hours and minute components

=ARRAYFORMULA(HOUR(D2:D - B2:B))

=ARRAYFORMULA(MINUTE(D2:D - B2:B))

Wowwww… Very Very Very Nice Post… I have just started holding up with GSheets and playing with formula. I am loving it and your post is just what i should be knowing… Cheers to you :clap: :clap: :beers:

1 Like

After you’re familiar with that you can try these too, hope it helps :smile:

1 Like

:heart_eyes: :cocktail:

1 Like

I would suggest to use “CopyDown” add on in Google sheet.

Take a look at this post, it may get your creative juices flowing.

1 Like

Thank you! Works great. Seems to be an easy solution to all my issues.

S

1 Like

My pleasure to help, Steven.