P
Psych-O-Delic Voodoo Thunder Pig
Hello, I want to convert a numeric value such as 46 or 9243, which
represents seconds, to minutes and seconds in the format mm:ss I could not
find a built-in function to do this. The numeric value is in a column that
is ASCII data imported from another system.
The closest I could find is =CONVERT(A1,"sec","mn") but it gives the
fractions of a minute in decicimal value rather than seconds (assume the
date is in A1). I tried modifying it to =CONVERT(A1,"sec","mn:sec") but it
doesn't work.
I finally jury-rigged this function together:
=QUOTIENT(A1,60)&":"&TEXT(MOD(A9160),"00") which works but seems rather
kludgy. Am I missing a built in function to do what I want?
Thanks,
jp
represents seconds, to minutes and seconds in the format mm:ss I could not
find a built-in function to do this. The numeric value is in a column that
is ASCII data imported from another system.
The closest I could find is =CONVERT(A1,"sec","mn") but it gives the
fractions of a minute in decicimal value rather than seconds (assume the
date is in A1). I tried modifying it to =CONVERT(A1,"sec","mn:sec") but it
doesn't work.
I finally jury-rigged this function together:
=QUOTIENT(A1,60)&":"&TEXT(MOD(A9160),"00") which works but seems rather
kludgy. Am I missing a built in function to do what I want?
Thanks,
jp