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!