By using this website, you agree to our Terms of Use (click here)
Hello,
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.
Thank you!
Try converting the time spent into decimal first using the formula CDec([PMTimeActivity.TimeSpent])/60. That should fix your issue.
-Kurt
That did it, thank you! That was an easy fix.