Skip to main content
Answer

Rounding billable time in Generic Inquiry

  • July 8, 2021
  • 2 replies
  • 216 views
S
Jr Varsity III
Forum|alt.badge.img

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.

Best answer by ChandraM

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

    2 replies

    C
    Semi-Pro I
    Forum|alt.badge.img+8
    • ChandraM
    • Semi-Pro I
    • Answer
    • July 8, 2021

    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

    Chandra M
    Kandy Beatty
    Chris Hackett
    D
    Jr Varsity III
    Forum|alt.badge.img
    • dgross54
    • Jr Varsity III
    • August 4, 2022

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

    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved