AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Live
  • Login
  • Start Here
  • Rolodex
  • Courses
  • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Generic I...
Time Card GI Decima...
 
Notifications
Clear all

Time Card GI Decimal Hours from Time Spent  

    Last Post
RSS

Grant-Westmill
Posts: 5
 Grant-Westmill
February 8, 2021 2:23 pm
(@grant-westmill)
2-5 Posts
Joined: 2 months ago

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.

Screenshot 2021 02 08 112007
Screenshot 2021 02 08 112105

 

Thank you!

2 Replies
Kurt Bauer
Posts: 32
 Kurt Bauer
February 9, 2021 8:42 am
(@kurtybauer)
21-50 Posts
Joined: 11 months ago

Try converting the time spent into decimal first using the formula CDec([PMTimeActivity.TimeSpent])/60.  That should fix your issue.

-Kurt

Reply
Grant-Westmill
Posts: 5
 Grant-Westmill
February 9, 2021 11:00 am
(@grant-westmill)
2-5 Posts
Joined: 2 months ago

That did it, thank you! That was an easy fix.

Reply
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,723 Topics
7,912 Posts
7 Online
1,169 Members

Latest Post: Shipments Picked and Packed Per Day Our newest member: ibvbghujhu05 Recent Posts Unread Posts

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×