Hi Mark,
I think you must approach an automated solution for this because doing this task manually will be a hectic job and will consume lot of time.
I know a software tool which can fulfill all your requirements and will assist you in keeping record of hours utilized by resource. You can try...