To create a customized report that will help with Payroll by showing Over Time hours, you can add two Calculated Columns to the Attendance by Day report.
IMPORTANT NOTE: This will only wok with Total Hours which are in 10ths of an hour- it will not work for Duration which is in minutes.
To create this report you will go to Reports from the home ribbon | All Reports | Employee | Time Clock | Attendance | Select Date Range | Execute from the ribbon | Calculated Columns |
First column to create:
Column Name = RegHrs | Column Header =Regular Hours | Data Type = System.Decimal | Format = g2 | Formula = If([TotalHours]>40,40,[TotalHours])
Second Column to create:
Column Name = OTHrs | Column Header = Overtime Hrs | Data Type = System.Decimal | Format = g2 | Formula = If([TotalHours]>40, ([TotalHours]-40),0)
Third Column to create:
Column Name = Duration | Column Header = Duration | Data Type = System.String | Format = (blank) | Formula = Concatenate(If(Len(Floor([TotalHours])) < 2, Concatenate('0', Floor([TotalHours])), Floor([TotalHours])), ':', If(Len(Floor(([TotalHours] - Floor([TotalHours])) * 60)) < 2, Concatenate('0', Floor(([TotalHours] - Floor([TotalHours])) * 60)), Floor(([TotalHours] - Floor([TotalHours])) * 60)))
Be sure to click Add after you create each calculated column.
Attendance by Day & OT Hours calculated columns
-
- 100 Club: Active Contributor
- Posts: 171
- Joined: Wed Aug 24, 2016 9:22 am
Attendance by Day & OT Hours calculated columns
Post by M1EnterpriseTech »
Enterprise Support Specialist
Return to “Enterprise: Reports”
Jump to
- SUPPORT / USING THIS FORUM
- ↳ 0. > SYSTEM REQUIREMENTS / RESOURCES
- ↳ System Requirements
- ↳ Mitchell 1 Homepage
- ↳ M1 Knowledgebase
- ↳ Shop Connection (Blog)
- ↳ Email: TECH SUPPORT
- ↳ Email: CUSTOMER SERVICE
- ↳ Email: PRODUCT CONTENT
- ↳ Contact SocialCRM Agent
- ↳ Frequently Asked Questions (FAQs)
- ↳ 1. > HOW THIS FORUM WORKS [READ FIRST!]
- ↳ FORUM FAQs
- ↳ FORUM RULES
- ↳ How to Register
- ↳ How to Change Password
- SHOP MANAGEMENT / REPAIR INFORMATION / RELATED PRODUCTS
- ↳ 2. > MANAGER SE - RESOURCES
- ↳ SE News
- ↳ SE Product Help
- ↳ m1files.com
- ↳ SE Knowledgebase
- ↳ M1 Videos+Quizzes
- ↳ SK Videos+Quizzes
- ↳ Reports Pack
- ↳ Workshops
- ↳ Polls
- ↳ 3. > MANAGER SE - BY PROGRAM AREA
- ↳ NEW: Time Manager
- ↳ Scheduler
- ↳ Database + Settings
- ↳ NEW >>> TIPS - Database / Settings
- ↳ Reports + Printing
- ↳ NEW >>> TIPS - Reports / Printing
- ↳ Parts + Ordering
- ↳ NEW >>> TIPS - Parts + Ordering
- ↳ Technical Issues
- ↳ Tips + Ideas
- ↳ 4. > MANAGER SE - OPTIONS
- ↳ ProSpect
- ↳ MessageCenter
- ↳ Accounting Link
- ↳ SocialCRM
- ↳ Credit Card Processing
- ↳ Manager Enterprise
- ↳ Enterprise: General
- ↳ Enterprise: Settings
- ↳ Enterprise: How To
- ↳ Enterprise: Accounting
- ↳ Enterprise: Reports
- ↳ 5. > BOLT-ON TECHNOLOGY / VOYOmotive
- ↳ Mobile Manager
- ↳ Message Pro
- ↳ Lube Sticker Pro
- ↳ Report Pro
- ↳ VOYO products
- ↳ 6. > PRODEMAND / SHOPKEYPRO / TRUCKSERIES
- ↳ Using ProDemand
- ↳ Model Coverage
- ↳ NEW! SureTrack FAQ
- ↳ ProDemand Support - Videos + Live Training
- ↳ Repair Product Content Support
- BUSINESS TOPICS [Discussions For REGISTERED Forum Users]
- ↳ MEMBER REPAIR TIPS
- ↳ Dodge Cars
- ↳ Dodge Trucks / Jeep
- ↳ Ford Cars
- ↳ Ford Trucks
- ↳ GM Cars
- ↳ GM Trucks
- ↳ Honda / Acura
- ↳ Nissan / Infiniti
- ↳ Toyota / Lexus
- ↳ VW / Audi
- ↳ Imports - Other
- ↳ About Bolt On Technology
- ↳ About Elite Worldwide
- ↳ VIN Decode