Skip to main content

Is there a way in which one can round the billable time from the CRPMTimeActivity table in a generic inquiry? 

In the Case Class the billable time is rounded by 0:05. So if the billable time is 83 min, I would need the GI to show 85 min or where the billable time is 57min, it should show 60min.

Hi @suemackeown13 Please try using the formula - DateAdd(Ceiling(Datediff(0,'m', '15:13') / 5.0) * 5,'m'), and le me if this works.

 

 

Thanks

I am trying to round to the nearest half hour.  I tried using this formula as is and it didn’t work.  I assume it is to test and then to substitute 15:13 for the date/time field?  Is “Ceiling” a function formula? 

 

DateAdd(Ceiling(Datediff(0,'m', '15:13') / 5.0) * 5,'m')

Reply


Terms & ConditionsCookie settings