Formula for Hours, Minutes and Seconds

Summary

Need formula for hours, minutes and seconds for a time difference in days

Content

I am trying to convert a Business Objects variable to OBI where it was using hours, minutes and seconds to convert the difference between 2 days.

Completion Time (Variable showing on report)
=ToDate([Time to Complete];"hh:mm:ss")

time to complete
=FormatNumber(Floor([Seconds to Complete]/3600) ;"0") + ":" + FormatNumber(Floor(Mod(Mod([Seconds to Complete] ;86400) ;3600)/60) ;"0") + ":" + FormatNumber(Mod(Mod(Mod([Seconds to Complete] ;86400) ;3600) ;60) ;"0") + ""

seconds to complete
=If(IsError(DaysBetween([Application Creation Date] ;[Application Completed Date]) * 86400
+
(
ToNumber(FormatDate([Application Completed Date];"HH")) * 3600 +
ToNumber(Left(FormatDate([Application Completed Date] ;"mm:ss") ;2)) * 60 +