Showing Duration field with words

[Leo_Flander]

I’m looking for a way to take a duration field (eg 1:32) and show it as “1 hours, 32 minutes” like with text.

I’m imagining there might be a formula I could use, but I’m not sure the best way to go about it.

Any thoughts would be great!

[YakirP]

If you are open to AI, you can use our API:

curl --location --request POST 'https://api.edgebrix.com/v1/task' \

--header 'Authorization: Bearer egb_xEuVTKKX..................' \

--header 'Content-Type: application/json' \

--data-raw '{

"input": "1:01",

"task": "convert duration field (eg 1:32) and show it as “1 hours, 32 minutes. Do not show if 0"

}'


Results:

{

"id": "H4PVQUAwbm0bPbQ",

"task": "convert duration field (eg 1:32) and show it as “1 hours, 32 minutes. Do not show if 0",

"input": "1:01",

"results": "1 hour, 1 minute"

}


Just signing to https://edgebrix.com, go to the "developers" tab, and get your API key!

Best,

Yakir