Create time sheet including analysis of work done.

I am a superviser on a construction site and I'm trying to create a timesheet. I want to keep track of how long each employee is working and, to make it more challenging, keep track of what category of work they're performing... This is where i find myself wandering outside of my pay grade, so bear with me if at all possible. Say cells A1 through A10 each contain the same dropdown menu with several categories(drive time, regular time, tower time, etc.) B1-B10 contain a start time, C1-C10 contain a stop time. D1-D10 each calculate the difference of time in the cells left of it. Now heres where i am lost. Cells E1-E10 would be titled drive time, regular time, tower time, regular out of town time, etc., and cells F1-F10 would total column D, based on the respective dropdown menu selection. I hope this makes sense, and someone can help me! I've been googling for days and its really bothering me!

Hi, and welcome to the forum. Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

As this is your first post I'll change the title for you but please note for future threads.

Originally Posted by ford88

i found the solution.

That's great.

One of the benefits of the forum is that others may also learn. Would you upload the solution you found for the future benefit of others.