Help converting and excel formula to smartsheet

rfgala

Hi everyone,

 

I'm pretty new to smartsheet so I may be asking your help for something that is quite easy to do

 

I have an excel formula that I need to migrate to smartsheet to help me transform seconds in HH:MM:SS

 

The excel formula is =TEXT(IF(I4="";50;I4)/(24*60*60);"hh:mm:ss") & ":00"

 

Is there a way to use the same formatting logic in smartsheet?

 

Thank you so much for your help

 

Rafael

 

rfgala

Can anyone help me here?