Hi! Thank you for making this API. I want to show in more user friendly ways the time and date of the video in a google sheet. How would I calculate/what formula would I use to show the date/time.
Thanks!
Nehmen Sie an der Diskussion teil - fügen Sie unten einen Kommentar hinzu:
My pleasure, thank you for using TikTok API.
That worked!! Thank you!
Hello,
You can convert the unix timestamp to date by using this trick: (A5 / 86400) + DATE(1970, 1, 1). Replace A5 with your values.
Best,
OM