TikTok API
Verified
✓
通过
Omar M'Haimdat |
已更新 23일 전 |
Data
人气
9.8 / 10
延迟
4,270ms
服务等级
100%
Health Check
100%
返回所有讨论
Calculating the time/date
juliaaaker
일 년 전
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!
加入讨论 - 在下面添加评论：
登录/注册以发布新的评论
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