sumif help neded for job sheet ?

**digga** · 01-31-2013, 03:07 PM

hi i am trying to do a job sheet to keep track of jobs and time taken have attached a sample sheet of what i have set up i have done one sheet for each month.
I have worked out to do the forumula to get how many hours i worked that day but the trouble im having is sometime i have more than one job on the go so cant just add up the whole column up but i believe i can use the sumif function to total up the hours spent on say fencing for example ? but when i tried this i didnt get the right hours for the whole month to put in the total hours on job ?

any help would be great

**FDibbins** · 01-31-2013, 03:13 PM

Hi digga and welcome to the forum

=SUMIF($E$2:$E$29,E2,$D$2:$D$29) should do it

but remember, it is summing hours, and an hour is a portion/fraction of a day. so 12 hours is actually 0.5 of a day, 6 hours is 0.25 etc. So ifg you add up your 3 samples, you come up with 1.125 DAYS. to convert that to hours * 24...=27 hours

**digga** · 01-31-2013, 03:53 PM

hi thank you for the quick reply :-) just thought of another problem and thats if the same job crosses over two sheet so say i started job in january and finished it in febuary will i still be able to total it up with out getting to complicated ? was thinking of wanting to put text ( job) and number total of hours in F please forgive the stupid questions still fairly new to excel but wanting to learn can see a lot of uses for excel once i get better at it

**FDibbins** · 01-31-2013, 08:31 PM

My suggestion would be to not use mutiple sheets for each month, but rather just use 1 sheet for all your data, and then use another sheet to do the summaries etc.

That way, it doesnt matter if a job spans months

Let me know if that is something you can work with?

**digga** · 02-01-2013, 10:14 AM

so instead of having a sheet for each month giving 12 in total put all the dates in column A with a gap of a couple or rows between each month
and leave the rest of the sheet as is ? .
all i basicly need for now is a way to keep track of what jobs i was doing and how long it took and then i can take that info and write out the invoice to the customer may want to change this at somepoint when im more familiar with excel but for now will be way better than the way i have been doing it of writing it all in a diary then having to add it all up to work out the invoice trying to work smarter and not harder.