Door open counter and time of days open

Getting Started
2

You could use the magnetic switch rather than a motion sensor to log all the activity to the cloud and then build a dashboard to visualize your data.

https://www.losant.com/blog/introducing-the-motion-sensor-kit

Here is a setup guide for your Photon and Losant if you're interested in taking that path.