Formula for Hours, Minutes and Seconds
Summary
Need formula for hours, minutes and seconds for a time difference in daysContent
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 +
0