Jump to content

"sumif" help


This topic is 5724 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Been awhile since I last made a post but could really use some help. I have created a data base to record hours related to specific jobs. This data will be compared to hours quoted. Here's the setup...

Each Job is Unique, with anywhere from one Activity entry to 30. An employee will punch in with his/her ID, Select JobID and Activity. Then later punch out giving an elapsed time. I've been able to create a portal to list all the punches in/out per job, but I can't figure out how to sum up hours per activity and compare to quoted hours. Quick Example:

JobID=1

Employee "A" punches in for "Painting" Activity for 1 hr. Employee "B" punches in for "Painting" Activity for 2 hrs. Employee "C" punches in for "Sanding" for 2 hrs.

Now when I go to Job Table I see a list of all three entries. What I can't get is a sum of all "Painting" hours and all "Sanding" hours based on the job.

I tried using "sum" but it just adds all records for all jobs. Tried "if" and "case" but couldn't make it work. Your help is greatly appreciated.

Link to comment
Share on other sites

Hey Raz,

Thanks for the quick response but that didn't work. The "elapsed time" isn't a summary field, it's a calc field "out" - "in". Should it be? If it is a summary field, won't it just total all the elapsed time fields, and not per each JOBID record. Any other help would be appreciated.

Link to comment
Share on other sites

Hello all,

Couldn't quite get what I wanted. Let Me give some more detail.I am trying to track hours assigned to jobs based on certain activities.

Job, LaborReq, and Activity Table. For every one job, there are multiple "punch-ins" for direct work. When an employee "punches in", a record is created on the LaborReq Table. On the LaborReq screen, I created a VL to JobID so each "punch-in" added to that jobs total, and a VL based on my Activities. I have been able to create a portal to list all laborreqs and sum the total through a summary field for each job. What I can't figure out is how to sum hours per job and by various activities. I was reffered to the getsummary function, which I did get to work, but only if I placed it in the activity table. I would like to get a total, for each Job and Activity, and place in its own field on the Job Table.

What I'm trying to do is track actual hours to quoted hours. I have a table for quoted hours, where it's data entry per our quote, and enter hours for each activity in it's own field. I want to have a report to compare the numbers side by side.

Any help or refference to another post will be most helpful. Thanks in advance.

Sorry about the double post. Know now when and where to post or add to existing post.

Link to comment
Share on other sites

This topic is 5724 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.