You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Formula for Hours, Minutes and Seconds

edited Dec 13, 2022 7:00AM in Taleo Enterprise

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 +

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!