Super cool, even though it’s showing 33:40 at the moment :-)

walty · on Dec 26, 2020

To fix it, you can change cell U1 from

  =iferror(regexextract(text(HOUR(A1),"##"),"^\d"),"0")

to

  =iferror(regexextract(text(HOUR(A1),"00"),"^\d"),"0")

The ## text format uses only as many digits as needed, while the 00 format pads to 0 digits.

helsinkiandrew · on Dec 26, 2020

And 44:43 to me an hour later (but in Helsinki time) perhaps a slight tweak is needed

MrsHippy · on Dec 26, 2020

I got 66:06 while now() == 06:06