Troubleshooting: Inconsistent Time Output Despite Same Input Format

·

I'm having an issue where some of the results im getting for a time output are populating differently despite having the same format of input

Alex
·
·
https://app.clay.com/workspaces/83297/tables/t_kusjZAmwLLrs/views/gv_qbJsDZ5TNOe4
Clay Team
APP
·
·
Hey Alex, thanks for reaching out! Is that the chatGPT Time Duration column?
Alex
·
·
Hey friend! Yes it is
Clay Team
APP
·
·
Cool! Was just checking it and maybe adding a few more examples with the corresponding format should help make it more consistent. Especially for cases where it has to output 3.5 years instead of "3 and a half years". You can skip the "example input" and just add a few "example outputs" so it understands those variations.
Clay Team
APP
·
·
Since you already ran many of them I used a Formula column to re-format them, right next to it. Hope this helps!