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....
App builders
Tables and fields
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)
    )