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

time format

Carlos Renteria

hi,

 

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.

time.jpg

 

thanks for your help!