Making a digital clock in Google Sheets(therobinlord.com)
therobinlord.com
Making a digital clock in Google Sheets
https://www.therobinlord.com/making-a-digital-clock-in-google-sheets/
14 comments
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!
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!
Thanks, I really enjoyed this. It brings me back to my Digital Logic Design class where we needed to construct the truth tables for a digital clock for our final exam.
Super cool, even though it’s showing 33:40 at the moment :-)
To fix it, you can change cell U1 from
=iferror(regexextract(text(HOUR(A1),"##"),"^\d"),"0") =iferror(regexextract(text(HOUR(A1),"00"),"^\d"),"0")
And 44:43 to me an hour later (but in Helsinki time) perhaps a slight tweak is needed
[deleted]
I got 66:06 while now() == 06:06
The time is now 99:51
What I learned from this is that formatting date/time as text will lead to all kinds of edge case bugs.
Really cool, but in my case it shows 77:27, has someone edited original?
Likewise 77:15 here (local 08:45 GMT 26th Dec)
I wonder if this could be some sort of timezone/locale issue screwing up his regexes ... Although there is no obvious 7 in my current time)
I wonder if this could be some sort of timezone/locale issue screwing up his regexes ... Although there is no obvious 7 in my current time)
So GSheets are turing complete, for all your 1 Hz computing needs?
They've always (?) had a script IDE you can use to create your own functions for use in cells so I guess it has always been Turing complete.
I've used the script IDE a lot where it just made sense to do something in about 10 lines/a for-loop of normal procedural code rather than an unreadable chain of about 50 spreadsheet formulas in one cells.
I've used the script IDE a lot where it just made sense to do something in about 10 lines/a for-loop of normal procedural code rather than an unreadable chain of about 50 spreadsheet formulas in one cells.
Can't you get a better, higher resolution clock simply by setting the time in a cell and setting the font size very large?
https://docs.google.com/spreadsheets/d/1T3bv8ThluHc18ghI8u9m...
Thank you for the inspiration!