Hello all,

I have just joined this forum after spending 2 days on Google and YouTube trying to figure out how to solve a problem myself, and coming up short. Any help would be much appreciated.

The back-story is that my dad had a major operation and as he can't go to work for some time he's been asked to produce some work from home, which he's asked me to help him with. I'm no expert at Excel but I've educated myself about the basics with YouTube tutorials, and have managed to get some formulas working, but have no idea how to come up with a couple that have left me stumped.

The time sheet is not a simple log in, log out, subtract lunch hour one - if it was I think I'd just about be able to manage it. Instead, it needs to consist of multiple jobs on a single machine throughout the day. He works in a print factory so a machine can have anywhere from 1-50 jobs per day. This is where I'm getting stuck - figuring out how to make a table that allows such a huge level of variance, and still works out a formula for however many jobs are put in. The aim of the timesheet is to compare the output of different workers to one another, to check how much time is being "wasted" between jobs, to compare expected output with actual output, as well as to easily see how many items have been produced per hour, per day, per week etc.

The subjects that I want are:

Name (of person running the machine), Machine Name, Clock In (for multiple jobs), Clock Out (for multiple jobs), Total

I also want other things such as quantity produced, but I think once I can figure this bit out myself.

I have seen a tutorial explaining how to subtract one time from another to arrive at a total, however I can't find anything that tells you how to do it for multiple times within one day. For instance, if someone called John logs in for the first job at 6:00am and logs out at 06:45, then logs in at 06:51 and logs out at 07:30, then logs in at 07:40 and logs out at 08:00, I want it to calculate that the total time was 1hr 44 mins or 104 mins, and I also want it to calculate the time "wasted" in between jobs which would be 16 minutes. The more that are added, eg 20 or 30 jobs, the more complicated it becomes. I thought about laying it out like this:

Name, Machine, Total, Clock In, Clock Out, Clock In, Clock out, Clock In, Clock Out etc etc

With 50 "clock in" and "clock out"s, but besides looking terrible any subsequent formula would be messed up by all of the empty slots.

I realise this is a whole lot of information and I have no idea if I've explained myself clearly enough, but if anyone can help I would be very thankful, and I hope nobody thinks I'm just being lazy about it - I have tried for a couple of days now.

Thanks in advance,

Rick