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.
