Creating a Formula to Convert Rapid API Output to Hours

Mladen J. · 2024-11-05T10:15:55.342565+00:00

Hello Team Is there a way to create formula which will convert me output from Rapid API in hours? and also remove "h" from output so I can properly sort them by size Output sometimes is in weeks, months or years

Arturo O.

·

Hey Mladen, thanks for the inquiry! Yes, that should be possible using the formula generator and AI. Of course, happy to look into the actual formula depending on what your expected output format and what the inputs looks like. Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1730826000&signature=128c7b8a99b446a125677ffd0985035c3bed5cf3b64307a28b8d66589dd0c1d9&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSv0BJEW2BKsam%2FhVPtetQ%3D%3D%0A

Mladen J.

·

Arturo O. Here you are Column recent activity I need to transfer all in number of hours but to remove "h" so I can filter results like numbers https://app.clay.com/workspaces/12283/workbooks/wb_CsR78J7nuZkv/tables/t_ZdyBeiK5q8oQ/views/gv_fr3s8PCuhfpT

Arturo O.

·

Thanks! Okay, so yeah, you can add a formula column to clean that up for sure. Using the AI formula generator to achieve the desired outcome. I added the example next to that original column, but feel free to edit it to update the formula if needed. https://downloads.intercomcdn.com/i/o/w28k1kwz/1240964989/a4a4ceb953184c663e6ecebe6e18/chrome_csS2L6HkVN.png?expires=1730837700&signature=46fabf26be15201537114e6185bf008cecd2bed06ac70117027caf575237de10&req=dSIjFsB4mYhXUPMW1HO4zUDQMUCPOJR%2BwTqZuAUZkbsTg3ImVBzveXMRKnGk%0AKljR%0A

Channeled

APP

·

This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

Mladen J.

·

Arturo O. but I also need to transfer when output is 1mo or 1w into number of hours not just remove letters

5 comments