Hi Experts:

I have a Macro that will pop time to a worksheet...the problem is I can't
determine how to make it pop with a left Zero fill if there are no hours.
Example: :47:57 change to 0:47:57 whe the Macro pops instead of the :47:57.

Can anyone tell me how to do this?

Thanks for your assistance,
--
jeannie v