Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Feedback & Requests

Creating a Formula to Convert Rapid API Output to Hours | Clay

Feedback & Requests

Creating a Formula to Convert Rapid API Output to Hours

·Nov 05, 2024 10:15 AM·

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

5 comments

· Sorted by Oldest

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 Clay 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