AnsweredAssumed Answered

How to convert seconds into HHH:MM:SS in boxi

Question asked by sanketkumar.d on Aug 24, 2016
Latest reply on Aug 30, 2016 by Besim Dzemaili

We have one timing field in universe defined as type-number . In rich client we are trying to convert this field into hh:mm:ss format . We have used the formula as follows :

=ToDate(If((IsNull([Zresponse Time])) Or([Zresponse Time] = 0 )) Then ("00:00:00")
Else FormatNumber(Floor([Zresponse Time] /3600) ;"00") + ":" +
FormatNumber(Floor(Mod([Zresponse Time] ;3600)/60) ;"00") + ":" +
FormatNumber(Mod(Mod([Zresponse Time] ;3600) ;60) ;"00");"HH:mm:ss")
 

but this is not supporting if the number of hours is three digit and displays errors in the rich client . Kindly guide on this .

Outcomes