Calculating the time/date

Question

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!

Omar M'Haimdat · Answer

My pleasure, thank you for using TikTok API.

julia aaker · Answer

That worked!! Thank you!

Omar M'Haimdat · Answer

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

TikTok API

9.8 / 10

4,270ms

100%

100%

Calculating the time/date