 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / August 2007Formula for calculationg hours worked per day
I'm creating a log for our employees to enter worked hours. The log has a client column, a weekday drop daown list, a date column, an employee name drop down list, a task description column, and an Hrs. column ( to enter amount of hours worked on that specific task). I have a Weekly Total section and what I would like to add is a section that adds the amout of hours worked by weekday ( 8 hrs. on monday, 7 hrs. on tuesday and so on ). I don't know what formula to use. Could you please help? I'm really stuck!!! Hello Please read the Link belo http://enterprise-solutions.swits.net/infopath2003/article.php?t=time-calculatio ns-using-rules&c=infopath2003 Hope it helps you  SignatureKalyan G Reddy - INFOPATH MVP 2007 http://www.ggktech.com > I'm creating a log for our employees to enter worked hours. The log has a > client column, a weekday drop daown list, a date column, an employee name [quoted text clipped - 4 lines] > tuesday and so on ). > I don't know what formula to use. Could you please help? I'm really stuck!!! That is helpful for a regular office employee. This are techs, so they split their time between customers. The entries look pretty much like this: Cutomer Day Date Task Hours Smith Tuesday 07/03/07 Work on VOIP 2.5 Johnson Thursday 07/05/07 PC Setup 4.0 Weekly Total 6.5 Now I want to have the following: Hrs Worked per Day Sat Sun Mon Tue Wed Thu Fri 0 0 0 2.5 0 4.0 0 Any ideas on what to use? > Hello > [quoted text clipped - 11 lines] > > tuesday and so on ). > > I don't know what formula to use. Could you please help? I'm really stuck!!! You can use the sum() function over the "Hours" field with a filter on the value of the "Day" field to calculate the total for each day field in your totals section. The formula could look something like: sum(../my:group1/my:group2/my:Hours[../my:Day = "Monday"]) to calculate the total hours over all rows that have "Monday" selected. You can use rules for this; no need to write code. The only disadvantage is that if you remove a row in your repeating table, the recalculation will not take place. You will have to use a button to perform the recalculation. If you need more instructions on how to get this done, let me know; I'll walk you through it. --- S.Y.M. Wong-A-Ton > That is helpful for a regular office employee. This are techs, so they split > their time between customers. The entries look pretty much like this: [quoted text clipped - 26 lines] > > > tuesday and so on ). > > > I don't know what formula to use. Could you please help? I'm really stuck!!! Thank you SO much! It actuallly worked great! > You can use the sum() function over the "Hours" field with a filter on the > value of the "Day" field to calculate the total for each day field in your [quoted text clipped - 42 lines] > > > > tuesday and so on ). > > > > I don't know what formula to use. Could you please help? I'm really stuck!!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.