Hello,

Is there anybody can help me to convert a time 34:23:10 (hh:mm:ss) in 1 day 12 hours 23 minutes and 10 seconds? Many thanks for your tips!

Dom

That would be extremely difficult.

However, if you are willing to accept 1 day 10 hours 23 minutes and 10 seconds as the result, try something like:

Let ( [

d = Div ( theTime ; 86400 ) ;

r = Mod ( theTime ; 86400 )

] ;

d & " day/s " & Hour ( r ) & " hour/s " & Minute ( r ) & " minute/s " & Seconds ( r ) & " second/s "

)

Thanks. It works perfectly. Sorry for the mistake about the total of hours. I just add a function If for putting the s when there's more than one day, hour, minute and/or second.