One way:

Textbox1.Text = Application.Text(myTime, "[hh]:mm:ss")

where myTime is your time value.

In article ,
rocketslinger wrote:

How do I prorammatically enumerate time past 24 Hrs and accurately
format the result for display in a userform (ex. 100:30 hrs)?
Suggestions greatly appreciated.