Questions Time Card GI Decimal Hours from Time Spent

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!