Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

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

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?
App builders
Tables and fields
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    Round(
      If([Duration (Manual)]<>Minutes(0),[Duration (Manual)],[Time out]-[Time In]),
      0.25
    )
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    7 years ago
    I get an error when i do this. "Expecting duration but found number
    • _anomDiebolt_'s avatar
      _anomDiebolt_
      Qrew Elite
      7 years ago
      Round(
        If([Duration (Manual)]<>Minutes(0),[Duration (Manual)],[Time out]-[Time In]),
        Hours(0.25)
      )