How to add :00 to a string

[Ramartin1]

Hi All,

I will like to add :00 to this time duration 188:00 string final result should 188:00:00. Is it possible to assist?

118:00 to 188:00:00 

Thank you,

[alisonpitt]

Hi Ramartin1 - what data types would you like to start and end with? If it's just string to string, you can do this with a formula tool like [Duration] + ":00"

Or is there nuance I'm missing?

[MarqueeCrew · Accepted solution]

Excellent response @alisonpitt !!!

[Ramartin1]

Thank you Alison!

That worked now I have to change that duration time 188:00:00 Data type (V_String) into seconds with DateTimeDiff([Duration],"00:00:00", "Seconds") the formula works up 24:00:00 but large numbers like the one I shared provides a [Null]. Any solution will be appreciated. 

Thank you,

[DataNath · Accepted solution]

I have assumed that the format is hours:minutes:seconds and you want to find this duration purely in seconds - apologies if this isn't the case! However, if so then I believe the following should work. If the format is different I'm happy to provide an alternative! Workbook attached.

[Ramartin1]

Thank You that work perfectly!