finished Poké Time Calculator

[Teritha]

I have created a spreadsheet that will calculate how long until certain time phases occur (Morning, Day, and Night), and what time that will be, in your local time or Poké Time.

You either need to be logged into Google Drive to create a copy for personal use, or download some other spreadsheet software to create your own copy (e.g. Microsoft Excel).

 

https://docs.google.com/spreadsheets/d/17Nl0X2xJuJnvzL-SgcgeIWqUtDlNwQxouEPbY2jFWpM/

 

Any suggestions for improving this would be appreciated.

Edited June 13, 2018 by Teritha

[Thejollypear]

I'll have to check it out some time. Sounds cool.

[Guest LiquidSnakeK]

I was just looking for how to calculate poketime per real time hour. As in how to translate what 1 real time hour translates into poketime. This spreadsheet seems helpful but the local time seems off. Since it can't read what my local time is atm, I'm not sure how to change that.

[Teritha]

Oh, that's strange. After you created your own copy, I imagined it would use your local time through the NOW function.

Anyway, 1 hour in real-time translates to 5 hours in poké time.

[Guest LiquidSnakeK]

Ah alright thanks. Seems to be a functional spreadsheet at any rate. Thanks for this

[Guest SugarRed9]

Thanks for this awesome spreadsheet!!!

[Barney]

aaaaand downloaded :D

 

thanks :y: