1

I want to get time in hours from the difference of two Date/Time fields. But currently for two Times such as 12 pm and 1 pm ,formula field is returning .04 hours . How is it getting calculated?

  • Are you trying in formula or in Apex – Sunny Dec 30 '15 at 4:32
  • Formula field . – Vanilla_Sky Dec 30 '15 at 4:32
  • So I read that its getting calculated like : For example, if the difference between two Date/Time values is 5.52, that means the two values are separated by five days, 12 hours (0.5 of a day), and 28 minutes (0.02 of a day). -- Any way I can get the numeric difference of the time ? – Vanilla_Sky Dec 30 '15 at 4:33
  • I am not sure exact solution, work around will be calculating the field again after return the result – Sunny Dec 30 '15 at 4:45
  • 4
    To get the result in hours, multiply by 24. For minutes, 1440 (60*24). – sfdcfox Dec 30 '15 at 4:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.