3 ms·
Super cool, even though it’s showing 33:40 at the moment :-)
by ed25519FUUU 6y ago
Super cool, even though it’s showing 33:40 at the moment :-)
- helsinkiandrew 6y agoAnd 44:43 to me an hour later (but in Helsinki time) perhaps a slight tweak is needed
- deleted 6y ago[deleted]
- MrsHippy 6y agoI got 66:06 while now() == 06:06
- walty 6y agoTo 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.