Discussions

Expand all | Collapse all

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

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

    Posted 07-25-2018 13:34
    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?


  • 2.  RE: I need my duration field to round to the nearest quarter hour.

    Posted 07-25-2018 13:51
    Round(
      If([Duration (Manual)]<>Minutes(0),[Duration (Manual)],[Time out]-[Time In]),
      0.25
    )


  • 3.  RE: I need my duration field to round to the nearest quarter hour.

    Posted 07-25-2018 13:57
    I get an error when i do this. "Expecting duration but found number


  • 4.  RE: I need my duration field to round to the nearest quarter hour.

    Posted 07-25-2018 14:16
    Round(
      If([Duration (Manual)]<>Minutes(0),[Duration (Manual)],[Time out]-[Time In]),
      Hours(0.25)
    )