Skip to main content
Question

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

  • July 25, 2018
  • 0 replies
  • 41 views
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?
This topic has been closed for replies.

  • anomDiebolt
  • Registered
  • July 25, 2018
Round(
  If([Duration (Manual)]<>Minutes(0),[Duration (Manual)],[Time out]-[Time In]),
  0.25
)
  • ArchiveUser
  • Author
  • Registered
  • July 25, 2018
I get an error when i do this. "Expecting duration but found number
Terms & ConditionsAccessibility statement