How do I convert a time to text format.
excel uses a serial number format for times (makes calculations easier) you
have to convert it using: =text(a1,"hh:mm:ss")
"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?
|