Help

Showing Duration field with words

Topic Labels: Formulas
3652 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Leo_Flander
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

10 Replies 10
YakirP
4 - Data Explorer
4 - Data Explorer

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