Hi... my simple code to convert a number to "h:nn:ss" works for just about any number, EXCEPT 6, 12, and 24.

Let's assume you have Two Controls on a Form:

txtTimeEntry.Text
lblTimeReturn

Now, here's the code:

------------------------------------------------

Private Sub txtEnter_Change()

lblTimeResult = txtEnter.Text / 24

lblTimeResult = Format(lblTimeResult, "h:nn:ss")

------------------------------------------------

This code works GREAT for any number you enter.

If you enter 2.5, you'll see... 2:30:00
If you enter 7.15, you'll see... 7:09:00

It's a great way to convert any digit to an hour equivalent, EXCEPT when the digit equals 6, 12, or 24.

If you enter 6, you'll see... 0:25:00 (when you want to see 6:00:00)
If you enter 12, you'll see... 0:05:00 (when you want to see 12:00:00)
If you enter 24, you'll see... 0:00:00 (when you want to see 24:00:00)

Any ideas or examples of a better "digit-to-time" conversion code?

THANKS!!!