Thread: Timesheet Regular Time and Overtime w/Account Codes

I am trying to calculate the hours on a timesheet to show how many hours went to which particular account code for regular time, and for overtime.
I have a timesheet set up wihere Col D has the account code…..Col E is start time……Col F is stop time……Col G is the total hours for that entry……Col H is the accumulative total for the entire timesheet.
Then off to the right there is a grid that shows all the codes (or at least ones used to this point, but there will need to be more added). Col P has the account codes listed (the ones used so far)……Col Q uses the following code: =IF(SUMIF($D$8:$D$155,"=1190.1",$G$8:$G$155)=0,"",SUMIF($D$8:$D$155,"=1190.1",$G$8:$G$155)) which will add up all the codes and distribute the hours into the appropriate code. Maybe there is a better way to do this, but I just don’t know how. I want to find a way to have it take anything over 40 hours and put that into Col R. This would also need to be broken out by account code just as it is in Col Q. Right now, all the hours go into Q, so that one will need to modified also so that only regular hours go in there.
Overtime is based on over 40 hours.

Originally Posted by karstens

I am trying to calculate the hours on a timesheet to show how many hours went to which particular account code for regular time, and for overtime.
I have a timesheet set up wihere Col D has the account code…..Col E is start time……Col F is stop time……Col G is the total hours for that entry……Col H is the accumulative total for the entire timesheet.
Then off to the right there is a grid that shows all the codes (or at least ones used to this point, but there will need to be more added). Col P has the account codes listed (the ones used so far)……Col Q uses the following code: =IF(SUMIF($D$8:$D$155,"=1190.1",$G$8:$G$155)=0,"",SUMIF($D$8:$D$155,"=1190.1",$G$8:$G$155)) which will add up all the codes and distribute the hours into the appropriate code. Maybe there is a better way to do this, but I just don’t know how. I want to find a way to have it take anything over 40 hours and put that into Col R. This would also need to be broken out by account code just as it is in Col Q. Right now, all the hours go into Q, so that one will need to modified also so that only regular hours go in there.
Overtime is based on over 40 hours.

Hi karstens,

Take a look at Chip Pearson's web site for more information on timesheets, it may help you.

http://www.cpearson.com/excel/overtime.htm

oldchippy

Thanks for the reply OldChippy...that is actually the site I have been using to help set this up. My situation seemed more compliated tho, with the account codes, etc. and I could not seem to figure out what to do!