7 ms·

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") Th

by walty 6y ago

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.