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,
Excellent response @alisonpitt !!!
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.
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?
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.
