Duration Expressions

[mykrobinson]

Curious, are there built in expressions to convert a duration into an hours and minutes automagically?

I am working on building a call tracking app, with the hopes to tie it in with APIs from the phone system vendor.

I set up a simple form to start and added a formula to call duration to calculate end time minus start time, but would love to convert the result for, say, 1:47 to "1 hr 47 min" or something like that. I added the virtual column "Call Duration in Minutes" just to play with the MINUTES() expression and experiment with a few different things and learn what i can do with the resulting duration value.

[Steve]

Looks like you've got what you need. What are you looking to us for?

[mykrobinson]

i "think" i'm good. I realize that by using CONCATENATE, I am converting the numbers to text, essentially, so I suppose i need a few columns to run calculations and conversions, then i need to decide what i want to actually display.

[Akshay1194]

Hiii mykrobinson,

can you please suggest me how to get call end time.

[SkrOYC]

I suggest you to take a look at this post by @Joseph_Seddik:

The notions of TIME and DURATION and how to use in... - Google Cloud Community