The command text(a1,"h:mm:ss") worked. Thanks.

"Rick" wrote:

I want to get a list of times into another database program. But the time
formatting is getting messed up. For example. A time of 0:31:10 when
imported into the other program becomes 0.021643519. How do I convert the
time into a text format that can be exported?