3 Replies Latest reply: May 15, 2012 12:22 PM by Carlos Adolfo Renteria RSS

    time format

    Carlos Adolfo Renteria



      i have two kind of time formats:


      00:01:10 wich is hh:mm:ss and 01:10 wich is mm:ss.


      i need to convert the second format to hh:mm:ss


      how can i do this?


      i've tried with timestamp# (date,'hh:mm:ss') and whit Date#(date,'hh:mm:ss) but it didn't do what i need.



      thanks for your help!