Add a Leading Zero if Length = 1, else do nothing

[sa34techer]

Please assist me using Power Query to create a custom column to Add a Leading Zero if Length = 1, else do nothing.

 

[dufoq3]

Text.PadStart([Hours], 2, "0")

[Greg_Deckler · Accepted solution]

@sa34techer Add a custom column:

if Text.Length([Hours]) = 1 then "0" & [Hours] else [Hours]