How to convert seconds to days,minutes,hours.

[Former Member]

How to convert seconds to days,minutes,hours.

[Former Member · Accepted solution]

Hi try this

Create a formula:

@seconds:

numberVar D:=int(Truncate ({Seconds_Field} /(24*60*60)))*24*60*60; 
numberVar H:=int(Remainder(Truncate ({Seconds_Field}/(24*60*60)),60))*60*60; 
CStr(int(Truncate ({Seconds_Field}/(24*60*60))),"##") & " D " & 
CStr(int(Remainder(Truncate({Seconds_Field}/(24*60*60)),60)),"##") & " H " & 
CStr(int(Truncate({Seconds_Field}-D-H)/60)),"##")& " M " & 
CStr(int(remainder(Truncate({Seconds_Field}-D-H)),60)),"##") & " S "

Regards,

Vinay