In college I did a presentation on China’s USD Holdings. At the time they had trillions of dollars. To me at the time there was no real difference between them except for the beginning letters. That lead me to research in more touch-able terms. What is the difference between a million, a billion, and a trillion? Here is the oft-repeated comparison:
One million seconds is 11 days and 14 hours
One billion seconds is 31 years and 8 months
One trillion seconds is 31,710 years
So it’s a big difference! In line with that I wanted to understand those time intervals in my own life so I developed this tool that can tell you in Excel any ordinal or interval you might be interested in for any date.