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)
)