x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 1 reply
  • Subscribers 239 subscribers
  • Views 1266 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
17
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
jes102063

Report Design Formula Help

SOLVED
Posted By

Does anyone have a quick formula to calculate employees total hours worked by date (sum of regular, overtime and double-time)? 

Any help is appreciated!

Parents
  • +1
    verified answer

    Set up a separate fomula for each pay ID and then total these together. For regular hours, the formula would be

    IF(pay ID ="1", Units)

    The record used is PR-Time. You would substitute the "1" with your specificic pay ID.

    Once you have the three formulas set up, you can just create another formula that adds those three together.

Reply
  • +1
    verified answer

    Set up a separate fomula for each pay ID and then total these together. For regular hours, the formula would be

    IF(pay ID ="1", Units)

    The record used is PR-Time. You would substitute the "1" with your specificic pay ID.

    Once you have the three formulas set up, you can just create another formula that adds those three together.

Children
No Data

*Community Hub is the new name for Sage City