News for hackers. Stuff that matters.

A comment on Making a digital clock in Google Sheets. Parent comment

Re:Making a digital clock in Google Sheets by walty on Saturday December 26, 2020 @12:36AM (#25541663)
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.
[ Parent | on HN ]

There are no comments on this comment yet.