Making a digital clock in Google Sheets

Re:Making a digital clock in Google Sheets by lbatchelor on Saturday December 26, 2020 @04:32AM (#25542365)

Ha! That is so cool. I was super interested in the idea so tried doing it myself without looking at your solution and came up with a quite an elegant solution using only 8 formulas and some named ranges (could be 4 if you inlined them more but I kept them separate for clarity).

https://docs.google.com/spreadsheets/d/1T3bv8ThluHc18ghI8u9m...

Thank you for the inspiration!

[ Parent | on HN ]

Re:Making a digital clock in Google Sheets by heinrichhartman on Saturday December 26, 2020 @06:27AM (#25542764)

Thanks for sharing. Really surprised how straight forward your solution is!

Learned about REGEXEXTRACT and parametrized Strings.

Powerfull stuff.

As my job involves more and more Google Sheets Engineering lately. I really appreciate this kind of hacks!

[ Parent | on HN ]