Create TeamAdd Your APIDocs
Log In
Sign Up

TikTok API

FREEMIUM
Verified
✓
By Omar M'Haimdat | Updated il y a 23 jours | Data
Popularity

9.8 / 10

Latency

4,270ms

Service Level

100%

Health Check

100%

Back to All Discussions

Calculating the time/date

Rapid account: Juliaaaker
juliaaaker
il y a un an

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!

Rapid account: Omarmhaimdat
omarmhaimdat Commented il y a un an

My pleasure, thank you for using TikTok API.

Rapid account: Juliaaaker
juliaaaker Commented il y a un an

That worked!! Thank you!

Rapid account: Omarmhaimdat
omarmhaimdat Commented il y a un an

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

Join in the discussion - add comment below:

Login / Signup to post new comments