Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Pad zero to left of [h]:mm:ss cells if no number already present
Thanks, That is what I'm looking for. It would have been nice to convert the values within the same cell, but it is an easy work around.- haru2002
- Post #6
- Forum: Microsoft: Office
-
Pad zero to left of [h]:mm:ss cells if no number already present
Thanks, just tried it by painting the [hh]:mm:ss format on the data. It adds a zero if there is already a figure in the hour section, but if there is nothing there, it remains as is. Did I do something wrong here?- haru2002
- Post #3
- Forum: Microsoft: Office
-
Pad zero to left of [h]:mm:ss cells if no number already present
I would like to pad a zero to the left of a time value if no number is already present to the left of the ":". I am importing a lot of data from another application. The data is in the format [h]:mm:ss. However, when the time value is less than one hour, nothing appears to the left of...- haru2002
- Thread
- Replies: 5
- Forum: Microsoft: Office
