In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Time Card GI Decimal Hours from Time Spent
We have a generic inquiry set up to summarize our Time Card hours. They show up in the format HH:MM.
I tried doing a pivot table but the results came out in minutes instead of hours.
So I added a column dividing the Time Spent by 60: =[EPTimecardDetail.TimeSpent]/60
I set it to the same Schema as the labor rate so it shows 4 decimal places.
But if I have a task that only, say 30 minutes have been clocked to, it rounds down to zero.
How can I get a column within the GI that shows the time spent in decimal hours (ideally 2 decimal places but 1 or even up to 4 would be fine)?
I saw some articles to set up a new DAC but I am not that advanced yet so I was hoping there would be an easier way to do it.
We are on 2020 R2.
Try converting the time spent into decimal first using the formula CDec([PMTimeActivity.TimeSpent])/60. That should fix your issue.
That did it, thank you! That was an easy fix.
Brilliant, this helped me out too!