# Open Weather Map Sunrise/Set Parsing

**URL:** https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832
**Category:** Off Topic
**Created:** [March 16, 2021, 4:00pm UTC](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832 "2021-03-16T16:00:43Z")
**Posts on this page:** 1
**Showing post:** 12

<div class="post-metadata">

### Author: ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [March 17, 2021, 6:16am UTC](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832/12 "2021-03-17T06:16:08Z")

</div>

This one is easy because Thunkable is using seconds since 1970 and what I do is connect a Google sheet as my data source and this sheet has two columns  
Unix-time and normal-time  
In the column normal time I have a formula  
=A2/86400+DATE(1970,1,1)+TIME(5,30,0)

Then in Thunkable I update cell A2 and read cell B2 which has my answer.

I use it to compute number of dates between two dates and other date functions.

---

_[View the full topic](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832)._