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
You can use this.
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
After you’re familiar with that you can try these too, hope it helps
I would suggest to use “CopyDown” add on in Google sheet.
Take a look at this post, it may get your creative juices flowing.
Thank you! Works great. Seems to be an easy solution to all my issues.
My pleasure to help, Steven.