duration between date created and date modified field

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
Trying to create a formula field where the result shows the difference between the [date created] and [date modified]

However I only want it to show the number of hours.

tried doing this but it come up with a weird date and time as a result

[date modified]-[date created]
Photo of oliver mah

oliver mah

  • 850 Points 500 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
you can make it a formula numeric field type.

ToHours([date modified]-[date created])
Photo of oliver mah

oliver mah

  • 850 Points 500 badge 2x thumb
this worked perfect - thanks