I wanted to make a spreadsheet that I could enter a date & time and calculate how much time (in years/dates/months/weeks/hours/minutes/seconds...)
I kept expanding on it. it serves very little functional purpose but it was fun... here is the file...
https://docs.google.com/spreadsheets/d/19WJ7ld-SN6kWfCec94NDu5yEk8Md04j9i_O7C4KtkYw/edit?usp=sharing
Some things I need help with
- my month calculator doesn't seem to work... for the future? (red on sample)
- my time to/from calculator seems to add 12 hours? i'm guessing I need to do it a different way... column f
- for calculators on specific days of every year (e.g. enter a birthday, and if you open the file in 2020 or 2024 i want it to show days to/from that same year...)
thoughts?
Thanks!