Hello,
As a basic user of excel in the past I've been able to do the easy stuff, but i've been tasked with creating a time card/daily report for my employer and am stuck trying to get a summary sheet to calculate out.
To start. My time sheet is made up of 7 days. (7 sheets) each day is set up with employee names (to be put in on a daily basis) and up to 5 different cost codes. The cost codes are manually entered for each day, and can and will change through out the week. I currently have over 25 cost codes (sheet 8) and im trying to have a summary sheet (sheet 9) that will automatically add the total hours for each cost code for each day. I have no idea what kind of formula to use to compile this information.
I know that you guys will likely need more info. I'll be happy to answer any questions
Thanks
Dennis
Bookmarks