I need my duration field to round to the nearest quarter hour.

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
Here is my formula.

If([Duration (Manual)]<>Minutes(0),[Duration (Manual)],[Time out]-[Time In])

I need it to round to the nearest .25 hour.  For example if it is 4.667 i want it to round to 4.75. If it is 10.15 i want it to round to 10.25. If it is 7.99 i want it to round to 8.0. How would I do this?
Photo of Gabe Messler

Gabe Messler

  • 100 Points 100 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,352 Points 20k badge 2x thumb
Round(
  If([Duration (Manual)]<>Minutes(0),[Duration (Manual)],[Time out]-[Time In]),
  0.25
)
Photo of Gabe Messler

Gabe Messler

  • 100 Points 100 badge 2x thumb
I get an error when i do this. "Expecting duration but found number"
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,272 Points 20k badge 2x thumb
Round(
  If([Duration (Manual)]<>Minutes(0),[Duration (Manual)],[Time out]-[Time In]),
  Hours(0.25)
)